[R] ROracle - fetch gives empty dataframe

[Don MacQueen]

This is what I would try next if I were in your situation; I don't 
know it will help.

Try
     con <- dbConnect(ora, "rado/only2admin at dbname")
instead of
    con <- dbConnect(ora, "rado/only2admin"

The default dbname is Sys.getenv("ORACLE_SID"), have you checked that?

For myself, when I make connections to Oracle 9i using ROracle, I use the form
      dbConnect,ora, user='oracleuid',dbname='adbname',password='whatever')

-Don

At 10:38 AM +0200 7/14/04, Rado Bonk wrote:
>Dear R-users,
>
>I was able to make ROracle package to connect to the DB (Oracle91, 
>64bit, on Solaris). But after executing siple SQL query, "fetch" 
>commaned gives me an empty dataframe.
>
>### RORACLE INSTALATION PROCEDURE ###
>R CMD INSTALL --configure-args='--enable-extralibs' 
>--enable-oracle32=no ~/tmp/ROracle_0.5-5.tar.gz  #since we have 
>64bit Oracle9i instalation
>
>PROBLEM: after executing simple statement, from within R, "fetch" 
>function gives me the empty dataframe:
>
>### CONNECTION, and SQL QUERY EXECUTION
>  > ora <- dbDriver("Oracle")
>  > con <- dbConnect(ora, "rado/only2admin"
>  > dbListTables(con)
>character(0)
>>  rs <- dbSendQuery(con, "desc * from si_r where id=498")
>>  d <- fetch(rs, n= -1)
>>  dim(d)
>[1] 0 3
>str(d)
>data.frame':   0 obs. of  3 variables:
>$ ID : int
>$ DAY: chr
>$ R  : num
>
>#### seems like connections has been established
>>  dbGetInfo(ora)
>$drvName
>[1] "Oracle (ProC/C++)"
>
>$connectionIds
>$connectionIds[[1]]
><OraConnection:(14939,0)>
>
>
>$fetch_default_rec
>[1] 500
>
>$managerId
><OraDriver:(14939)>
>
>$length
>[1] 10
>
>$num_con
>[1] 1
>
>$counter
>[1] 1
>
>$clientVersion
>[1] "0.5-4"
>
>Maybe it is something stupid (and I need just a hint), or may be it 
>is something major.
>
>Thanks in advance,
>
>Rado Bonk
>
>
>--
>Dr. Radoslav Bonk
>European Commission - DG Joint Research Centre (JRC)
>Institute for Environment and Sustainability (IES)
>LM Unit - Natural Hazards
>Weather Driven Natural Hazards Action
>Via E. Fermi, TP 261, 21020 Ispra (Va), Italy
>Tel.: 0039-0332-786013
>Fax: 0039-0332-786653
>Webpage: http://natural-hazards.jrc.it/floods/
>
>______________________________________________
>R-help at stat.math.ethz.ch mailing list
>https://www.stat.math.ethz.ch/mailman/listinfo/r-help
>PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html


-- 
--------------------------------------
Don MacQueen
Environmental Protection Department
Lawrence Livermore National Laboratory
Livermore, CA, USA