[R-sig-DB] dbListTables fails with Oracle
David James
dj @end|ng |rom re@e@rch@be||-|@b@@com
Fri Nov 7 03:24:07 CET 2003
Hi,
That problem appears(?) to be coming from the generated code by
the pre-compiler Pro*C/C++. In any event I've put a workaround
(plus a couple of other bug fixes) in the latest version which will
appear in CRAN sometime soon. In the meantime you may download a
pre-release version at http://stat.bell-labs.com/RS-DBI
Hope this helps,
--
David
Vadim Ogranovich wrote:
> Hi,
>
> I just installed ROracle under R1.8.1 alpha. There is a funny error in
> dbListTables(). When you run dbListTables just after establishing a
> connection it fails at oraQuickSQL(conn, "select table_name from
> all_tables")[, 1], see below. However if you execute oraQuickSQL(conn,
> "select table_name from all_tables")[, 1] from the prompt it will work
> fine and, moreover, the dbListTables() will work fine after that too.
>
> > library("DBI"); library("ROracle")
> > con <- dbConnect(dbDriver("Oracle"), user="...")
> > dbListTables(con)
> Error in oraQuickSQL(conn, "select table_name from all_tables")[, 1] :
> incorrect number of dimensions
> > oraQuickSQL(conn, "select table_name from all_tables")[, 1]
> Error in .class1(object) : Object "conn" not found
> > oraQuickSQL(con, "select table_name from all_tables")[, 1]
> *** works fine:output flushed ***
> > dbListTables(con)
> *** works fine:output flushed ***
>
>
> Any clue?
>
> Thanks,
> Vadim
>
>
>
> > version
> _
> platform i686-pc-linux-gnu
> arch i686
> os linux-gnu
> system i686, linux-gnu
> status alpha
> major 1
> minor 8.1
> year 2003
> month 11
> day 05
> language R
>
>
> [[alternative HTML version deleted]]
>
> _______________________________________________
> R-sig-DB mailing list -- R Special Interest Group
> R-sig-DB using stat.math.ethz.ch
> https://www.stat.math.ethz.ch/mailman/listinfo/r-sig-db
--
David A. James
Statistics Research, Room 2C-253 Phone: (908) 582-3082
Bell Labs, Lucent Technologies Fax: (908) 582-3340
Murray Hill, NJ 09794-0636
More information about the R-sig-DB
mailing list