sql - Issue with fetch in ROracle -

i having issues on retrieving large amount of data using roracle (i have read-only rights on oracle database) data involved exceeds > 4 gigs not able use dbgetquery roracle works perfectly.

instead trying use dbsendquery + fetch seems not working oracle. (it works rmysql package)

for example :

with oracle version:

dbgetquery(con2, "select * product_component_version")                               product    version     status                               nlsrtl  10.2.0.3.0 production   oracle database 10g enterprise edition  10.2.0.3.0       prod                               pl/sql  10.2.0.3.0 production              tns 32-bit windows:  10.2.0.3.0 production 

if try:

query <- "select * bfmxml_suivi" rs <- dbsendquery(con2, query, bulk_read = 10000l, prefetch = t) test <- fetch(rs, n = 10) dim(test) 

[1] 1 13

dbgetrowcount(rs) 

[1] 1

but expect 10 rows...

then fetching again:

test <- fetch(rs, n = 10) dim(test) 

[1] 1 13

dbgetrowcount(rs) 

[1] 1

hence, next row not fetched , looking @ result of 'test', can see filled in zeros (which not right + not case first fetch call)

do see alternative / solution?

quick ones, , should add have no oracle backend handy test this:

1. i prefer single res <- dbgetquery(con, query) call on dbsendquery() , fetch() combination.

2. i recall prior discussions on r-sig-db list stated backends 'lie' amount of data being ready retrieved, using n = -1 offered fix. may have been in context of rodbc.