[R] ROracle - fetch gives empty dataframe

From: Rado Bonk <rado.bonk_at_jrc.it>
Date: Wed 14 Jul 2004 - 18:38:49 EST


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
Received on Wed Jul 14 18:46:19 2004

This archive was generated by hypermail 2.1.8 : Fri 18 Mar 2005 - 02:36:03 EST