I have encountered *many* problems when using ROracle functions, including
the same problem with the one listed below (but I had such problem when
using dbExistsTable() instead of dbListTables).
My settings:
ROracle "0.5-5"
DBI "0.1-8"
Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production
JServer Release 9.2.0.6.0 - Production
Linux
I am wondering whether or not ROracle *can* work in such settings.
-Jing
----------------------------------------------------------------------------
----
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