[R] ROracle - fetch gives...(corrected SQL code)

From: Rado Bonk <rado.bonk_at_jrc.it>
Date: Wed 14 Jul 2004 - 19:08:03 EST


Sorry for posting the second time, I corrected the SQL code:

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"
>link2"><a name="0755qlink2">ame="0755qlink2">name="0755qlink2"> name="0755qlink2"><a name="0755qlink2">ame="0755qlink2"> dbListTables(con)
character(0)

> rs <- dbSendQuery(con, "select * from si_r where id=498")

                           ^^^^^^ CORRECTION

> 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 connection 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 19:16:04 2004

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