[R-sig-DB] dbListTables fails with Oracle

[Vadim Ogranovich]

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]]