[R-sig-DB] ROracle returning zero rows

[Vikram Khurana]

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