[R-sig-DB] ROracle didn't work properly in such setting

[Jing Zhou]

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