R help - Oct 2003 - Oracle fetch problems

Hi,

I use the ROracle interface in the R 64bit version.
When I fetch a large number of rows from the database I get alternating 
250 rows of what I want to see and than 250 rows junk and so on.
It does not matter whether I use the fetch command or dbGetquery or 
whatever. My fetch_default_rec = 500 and I can not change it by setting 
it explicitly in Oracle().
Any idea what's the problem here?

Thanks, joerg

Concerning my former message: I just found out that irrespective of the 
fetch size, I get always half of the fetch size good results/rows and 
the other half is corrupted. Strange, isn't?

relating to my former messages concerning the strange fetch problems I 
have, I found out that 'fetch' fetches only every second row of the 
'native' SQL-results and fills up the rest of the rows with zeros.
Here a draft for the native SQL-query:

12:43:07 SQL>  SELECT OBS_DAY, OBS_YEAR, STAT_ID FROM WILD_PHENO_OBS 
WHERE PHASE_ID=7 AND OBS_YEAR BETWEEN 1951 AND 2000 order by stat_id, 
obs_year, obs_day;
PLEASE HIT RETURN TO CONTINUE

   OBS_DAY   OBS_YEAR    STAT_ID
---------- ---------- ----------
       133       1954   11110000
       140       1955   11110000
       147       1956   11110000
       133       1957   11110000
       146       1958   11110000
       118       1959   11110000
       132       1960   11110000
       120       1961   11110000
       138       1962   11110000
       144       1963   11110000

Here what fetches R:

 >  DBres <- dbSendQuery(DBcon, "SELECT OBS_DAY, OBS_YEAR, STAT_ID
FROM
WILD_PHENO_OBS WHERE PHASE_ID=7 AND OBS_YEAR BETWEEN 1951 AND 2000 order 
by stat_id, obs_year, obs_day")
 >  fetch(DBres,n=10)
  OBS_DAY OBS_YEAR  STAT_ID
0     140     1955 11110000
1     133     1957 11110000
2     118     1959 11110000
3     120     1961 11110000
4     144     1963 11110000
5       0        0 11110000
6       0        0 11110000
7       0        0 11110000
8       0        0 11110000
9       0        0 11110000
 >

Any idea what's the problem here?