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