search for: dbpreparestatement

...uck with this problem and appreciate receiving help from gurus on this list. Code used mainly is: library(ROracle) ### --- Version 0.53 drv <- dbDriver("Oracle") con <- dbConnect( drv, "user/passwd") d <- data.frame(CDATE = "2004-03-10 10:12:00") ps <- dbPrepareStatement(con, "INSERT into DATEST (CDATE) VALUES ( :1 ) ", bind=c( "character")) ## -- c("date") does not work sapply(d, class) d$CDATE <- as.character(d$CDATE) sapply(d, class) dbExecStatement(ps,d) Error in oraExecStatement(ps, data, ...) : RS-DBI driver:...

Hi, first thanks to Sunny Ho (and David James for the pointer) for resolving the problem of the empty rows returned from ROracle. However, I have a problem still: > library(ROracle) > ora <- dbDriver("Oracle") > con <- dbConnect(ora, user = USER, password = PWD, dbname = DBNAME) > rs <- dbExecStatement(con, "select * from USER_TABLES") Error in

...* This version has an experimental dynamic SQL binding to data frames. SQL statements can be "prepared" (parsed and cached for improved performance), and columns of data frames bound to them for automatic data transfer). For details see the help() for "Oracle", "dbPrepareStatement" and "dbExecStatement". * Host arrays are now operational. These are buffers used by Oracle's internal implementation to reduce network traffic and speed up fetches and prepared statements. Currently fetches use a default buffer size (host arrays) of size 500 (previous ve...

...(prd_id,vol_factor) values(456,.456)") > dbGetQuery(conn,"select * from mytable") PRD_ID VOL_FACTOR 0 123 0.123 1 456 0.456 the above works as expected. Now let's try to insert new rows into mytable using a prepared statement and bind variables: > ps<-dbPrepareStatement(conn,"insert into mytable (prd_id,vol_factor) values (:1,:2)",bind=c(rep("numeric",2))) > res<-dbExecStatement(ps,my.df) > dbCommit(conn) [1] TRUE > dbGetQuery(conn,"select * from jdomenge_test") PRD_ID VOL_FACTOR 0 123 0.123 1 456 0.456 2...

...;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

...ext html latex example dbDriver-methods text html latex example dbGetInfo-methods text html latex example dbListTables-methods text html latex example dbObjectId-class text html latex example dbPrepareStatement-methods text html latex example dbReadTable-methods text html latex example dbSendQuery-methods text html latex example dbSetDataMappings-methods text html latex example fetch-methods text html...

Dear List, Would anyone know how to perform prepared queries with ROBC ? I had a shot with some of the internal (non-exported) functions of the package but ended up with a segfault, so I prefer asking around before experimenting further... Thanks, Laurent