[R] Issue with ROracle and results not being returned

[Coburn Watson]

Hello,

I am using ROracle 5.5 with R 1.8.1. I am connecting to an oracle database
, issuing a query and attempting to fetch data from the result set.  I can see my 
session in the oracle database as well as the sql which was executed (including number of blocks hit, etc). 
 I have also verified that the SQL returns a valid result set from sqlplus.

Below is a sample trace of my session:

> library(ROracle)
> drv <- dbDriver("Oracle")
> con <- dbConnect(drv,"perf/perf at pc2ac1")
> rs1 <- dbSendQuery(con, statement = paste ("SELECT distinct api FROM et_log_data order by api"))
> df<- fetch(rs1,n=-1)
> summary(rs1,verbose=T)
<OraResult:(25657,0,3)>
  Statement: SELECT distinct api FROM et_log_data order by api
  Has completed? yes
  Affected rows: 0
  Rows fetched: -1
  Fields:
  name    Sclass     type len precision scale isVarLength nullOK
1  API character VARCHAR2  50         0     0        TRUE  FALSE
> summary(df,verbose=T)
     API
 Length:0
 Class :character
 Mode  :character
> df
[1] API
<0 rows> (or 0-length row.names)
> q()

Any ideas on why the data cannot be retrieved into the df object?   Please remove "_nospam" from email address to email me directly.  
Any help would be appreciated.

Coburn

(sample output from query via sqlplus)
SQL> SELECT distinct api FROM et_log_data order by api
  2  ;

API
--------------------------------------------------
ADD_ACCOUNT
ADD_COMMENT
ADD_DLR_CH_SUB
..........
.... 54 total rows returned