[R-sig-DB] request of info
ur
jo@qu|n@ord|ere@ @end|ng |rom d|m@un|r|oj@@e@
Thu Sep 8 00:45:10 CEST 2005
Hello
I'm trying to set up a ROracle package and I get some problems:
Context:
Server: Oracle 10.1.0.2.0 database
Client: Oracle tools 10.2.0.1.0 running on Scientific Linux 4, which is a clone of RHEL4
sqlnet running like it is shown here:
bash-3.00$ sqlplus user/pass using oracle
SQL*Plus: Release 10.2.0.1.0 - Production on Wed Sep 7 19:15:16 2005
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> select max(fecha) from extrusoras;
MAX(FECHA
---------
03-JUN-05
From R side
R v 2.1.1
ROracle_0.5-5
I was buiding the ROracle library from source with special care for troubles like sqlclu and sqlca:
R CMD INSTALL --configure-args='--enable-extralibs="-lsqlplus -lecpg"' ROracle_0.5-5.tar.gz
> library(ROracle)
Loading required package: DBI
> drv<-Oracle()
> con<-dbConnect(drv,"user/pass using oracle")
> rs<-dbSendQuery(con,"Select max(fecha) from extrusoras")
> dat<-fetch(rs,n=-1)
> dbHasCompleted(rs)
[1] TRUE
> dbClearResult(rs)
[1] TRUE
> dat
[1] MAX(FECHA)
<0 rows> (or 0-length row.names) <= mistake (it provides no answer !!!! )
> rs<-dbSendQuery(con,"Select max(fecha) from extrusoras")
> dat<-fetch(rs,n=-1)
> dbHasCompleted(rs)
[1] TRUE
> dat
[1] MAX(FECHA)
<0 rows> (or 0-length row.names) <= all times is here the mistake
> dbClearResult(rs)
[1] TRUE
It seems to have a problem with the implementation for ROracle functions.
Could you help me a little bit ?
Many thanks
joaquin
[[alternative HTML version deleted]]
More information about the R-sig-DB
mailing list