Hi, I just installed ROracle and RDBI. The connection to the database seems to work also. My problem is when I am selection rows that really exist in the database, it is returning nothing. Where should I look to see what could be my problem?
Thank you very much, Mathieu > drv <- dbDriver("Oracle") > summary(drv, verbose=TRUE) <OraDriver:(6721)> Driver name: Oracle (ProC/C++) Max connections: 10 Conn. processed: 8 Default records per fetch: 500 Oracle R/S client version: 0.5-4 RS-DBI version: 0.1-9 Open connections: 2 1 <OraConnection:(6721,0)> 2 <OraConnection:(6721,7)> > > conn <- dbConnect(drv, "mathieu/[EMAIL PROTECTED]") > summary(conn, verbose=TRUE) <OraConnection:(6721,7)> User: mathieu Dbname: MYDB Oracle Server version: > > rs <- dbSendQuery(conn, statement = paste("select * from cat")) > summary(rs, verbose=TRUE) <OraResult:(6721,7,2)> Statement: select * from cat Has completed? no Affected rows: 0 Rows fetched: -1 Fields: name Sclass type len precision scale isVarLength nullOK 1 TABLE_NAME character VARCHAR2 30 0 0 TRUE FALSE 2 TABLE_TYPE character VARCHAR2 11 0 0 TRUE TRUE > > myContent <- fetch(rs, n = -1) > myContent [1] TABLE_NAME TABLE_TYPE <0 rows> (or 0-length row.names) > summary(myContent, verbose=TRUE) TABLE_NAME TABLE_TYPE Length:0 Length:0 Class :character Class :character Mode :character Mode :character > summary(rs, verbose=TRUE) <OraResult:(6721,7,2)> Statement: select * from cat Has completed? yes Affected rows: 0 Rows fetched: -1 Fields: name Sclass type len precision scale isVarLength nullOK 1 TABLE_NAME character VARCHAR2 30 0 0 TRUE FALSE 2 TABLE_TYPE character VARCHAR2 11 0 0 TRUE TRUE ______________________________________________ R-help@stat.math.ethz.ch mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html