search for: oraresult

...lt;- dbConnect(drv, "mathieu/toto at MYDB") > 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...

Hello, I am trying to configure my system with ROracle. I am running RHEL 3 AS x86_64. I have the Oracle client 9.2.0.4 x86_64. I have successfully compiled and run both R-1.8.1 and R-1.9.0 (tried ROracle on both installations). I am using DBI 1.8 and ROracle 0.5-4. I have used both the default Redhat installed gcc 3.2.3 and gcc 3.4. I am able to compile ROracle successfully with the

...on:(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...

Dear R-users, I was able to make ROracle package to connect to the DB (Oracle91, 64bit, on Solaris). But after executing siple SQL query, "fetch" commaned gives me an empty dataframe. ### RORACLE INSTALATION PROCEDURE ### R CMD INSTALL --configure-args='--enable-extralibs' --enable-oracle32=no ~/tmp/ROracle_0.5-5.tar.gz #since we have 64bit Oracle9i instalation PROBLEM:

...ext html latex example OraConnection-class text html latex example OraDriver-class text html latex example OraObject-class text html latex example OraPreparedStatement-class text html latex example OraResult-class text html latex example Oracle text html latex example S4R text html latex dbCallProc-methods text html latex dbCommit-methods text html latex exa...