[R-sig-DB] request of info

[ur]

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]]