[R-sig-DB] ROracle returning zero rows
David James
dj @end|ng |rom re@e@rch@be||-|@b@@com
Wed Jul 7 14:25:21 CEST 2004
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
More information about the R-sig-DB
mailing list