[R] Problem in fetching from Oracle

Minghua Yao myao at ou.edu
Mon May 12 17:10:27 CEST 2003


Dear all,

I tried the following in R:

 >library(ROracle)
 >ora <- dbDriver("Oracle")
 >channel <- dbConnect(ora, user = "scott",
password="tiger",dbname="abcdef")
 >rs <- dbSendQuery(channel, "select * from USArrests")

 >while(!dbHasCompleted(rs))
  {
  	xxx <- fetch(rs, n = 5000)
  }
+ + + > xxx
Error: Object "xxx" not found

If I changed xxx to df and typed df, I got
+ + + > df
function (x, df1, df2, log = FALSE)
.Internal(df(x, df1, df2, log))
<environment: namespace:base>
>

Please help. Thanks.

Minghua




More information about the R-help mailing list