[R] Oracle RODBC/ROracle(W2k)
Christian Schulz
ozric at web.de
Wed Jan 21 12:49:44 CET 2004
Hi,
trying the access to Oracle via ODBC in Win2k/1.8.1 i have only 2 problems.
(1) number(x,y) formats in oracle result in R-Project as a factor with more
than 20.000 levels for every distinct value.
My coversion attempts until now failed, i.e. as.numeric(money) result
in a:
Error in as.double.default(money) : (list) object cannot coerced to double
(2) A attempt to save a data.frame result in a:
Error in sqlSave(channel,SAVETTEST,colnames=T)
Missing column name
Check case conversion parameter in odbcConnect
Now i see the table with headers and without rows in oracle.
P.S.
Anyboddy know why this error occur(win2k,1.8.1!)?
Installation and compiling of (DBI) and (ROracle) works
fine. Now i try the example from docs:
library(DBI)
library(ROracle)
ora <- dbDriver("Oracle")
Error in .Call("RS_Ora_init",config.params,reload,Package=.OraPkgName)
.Call function name not in load table
Maybe a missing environment variable?
Many thanks for hints to fix this
problems,
Christian
More information about the R-help
mailing list