[R] ROracle returning zero rows

From: Vikram Khurana <vkhurana_at_mail.nmfs.hawaii.edu>
Date: Fri 02 Jul 2004 - 11:12:18 EST


Hi,

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

> 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.
Please cc me on the reply as I'm not subscribed to the R list.

Thanks for your time,
Vikram



R-help@stat.math.ethz.ch mailing list
https://www.stat.math.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html Received on Fri Jul 02 11:34:19 2004

This archive was generated by hypermail 2.1.8 : Wed 03 Nov 2004 - 22:54:39 EST