Re: [R] ROracle - fetch gives empty dataframe

From: Don MacQueen <macq_at_llnl.gov>
Date: Thu 15 Jul 2004 - 00:28:10 EST

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

______________________________________________
R-help@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
Received on Thu Jul 15 00:36:06 2004

This archive was generated by hypermail 2.1.8 : Wed 03 Nov 2004 - 22:54:57 EST