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/