[R] ROracle returning zero rows
vkhurana at mail.nmfs.hawaii.edu
Fri Jul 2 03:12:18 CEST 2004
I have ROracle 0.5-5 installed on RH 7.2 machine trying to access Oracle
8.1.7 and DBI 0.1-8
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
> ora = Oracle()
> con <-oraNewConnection(ora,username="user",password="pwd",
> dbGetQuery(con,"select * from test where rownum<9")
 VESSEL_CODE CRUISE_NUMBER EVENT_YEAR EVENT_MONTH EVENT_DAY
 MIN_OCTANT MAX_OCTANT
<0 rows> (or 0-length row.names)
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
Please cc me on the reply as I'm not subscribed to the R list.
Thanks for your time,
More information about the R-help