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 ______________________________________________ [EMAIL PROTECTED] 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