search for: dbpreparestat

Displaying 7 results from an estimated 7 matches for "dbpreparestat".

2004 Mar 10
2
Inserting Date Field into Oracle table using ROracle
...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 dr...
2004 Dec 09
1
ROracle/DBI problem with dbExecStatement on RH Linux
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
2003 Apr 22
0
ROracle 0.5-0 package update
...* 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 (previo...
2009 Jun 04
0
ROracle: cannot insert several columns
...(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....
2008 Dec 24
0
Write a data frame to Oracle Data Base
...;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
2009 Feb 09
0
ROracle - ORA-02005: implicit (-1) length not valid for this bind or define datatype
...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 htm...
2006 Feb 27
4
prepared query with RODBC ?
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