[R] Write a data frame to Oracle Data Base
usstata
usstata at 126.com
Wed Dec 24 05:52:34 CET 2008
Hi guys:
When I use the ROracle package, I found the function 'dbWriteTable'
can't work.
The data frame can't be written to 10g Oracle Data Base. Here is what
happened to me.
>library(DBI)
>library(ROracle)
>drv <- Oracle()
>con <- dbConnect(drv , 'uid','pw','db')
>mm <- data.frame(CO2)
> dbWriteTable(con,'eve_tmp',mm)
Error in function (classes, fdef, mtable) :
unable to find an inherited method for function "dbPrepareStatement",
for signature "OraConnection", "character", "list"
[1] FALSE
And I tried the RODBC package, 'write' function is OK.
Is it the Oracle version' problem? : (
Best regards
More information about the R-help
mailing list