[R-sig-DB] ROracle returning zero rows

[David James]

Hi Vikram,

I've had several reports of the same problem -- all running
Oracle 9 from Linux.  AFAIK this problem does not occur on
other platforms or other Oracle versions.  Unfortunately, I
my setup is is different.

--
David

Vikram Khurana wrote:
> Hi,
> 
> I have ROracle 0.5-5 and DBI 0.1-8 installed on RH 7.3 machine trying to
> access Oracle 8.1.7 
> Other config:
> Gcc 2.96
> R 1.9.1 patched
> 
> 
> I can get to Oracle using sqlplus & retrieve the data from the table "test".
> However when I try doing the same using ROracle I get the following
> 
> > library("ROracle")
> > ora = Oracle()
> > con <-oraNewConnection(ora,username="user",password="pwd",
> dbname="database SID")
> > dbGetQuery(con,"select * from test where rownum<9")
> [1] VESSEL_CODE   CRUISE_NUMBER EVENT_YEAR    EVENT_MONTH   EVENT_DAY
> [6] MIN_OCTANT    MAX_OCTANT
> <0 rows> (or 0-length row.names)
> > dbListTables(con)
> character(0)
> 
> When I do a dbGetQuery, I get just the column names of the table show up &
> no data. There are 1000+ rows in this table in the database.
> When I do a dbListTables, I get no results, which is not true
> 
> What is the issue here? Am I doing something wrong?
> 
> I have googled on it & found another person with the same problem, but no
> solution.
> 
> Thanks for your time,
> Vikram
> 
> _______________________________________________
> R-sig-DB mailing list -- R Special Interest Group
> R-sig-DB using stat.math.ethz.ch
> https://www.stat.math.ethz.ch/mailman/listinfo/r-sig-db