[R-sig-DB] dbListTables fails with Oracle

[David James]

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