Write a data frame to Oracle Data Base
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