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

[Rado Bonk]

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"
 > 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/