search for: orapreparestatement

Hello everybody, I found that queries (send by "dbExecStatement" ) with more than 4000 characters length produces an error in ROracle (ver 0.3-3). Maybe there is a limitation of 4kB.... Is this a bug? If yes, is this problem solved in the latest version of ROracle (ver 0.5-0)? My system information: platform sparc-sun-solaris2.8 arch sparc os solaris2.8

...or shown below > > > > dbExecStatement(ps,d) > > > > Error in oraExecStatement(ps, data, ...) : > > RS-DBI driver: (unrecognized S class factor ) > > > > > ps <- dbPrepareStatement(con, lQry, bind=c("date")) > > Error in oraPrepareStatement(conn, statement, bind, ...) : > > RS-DBI driver: (unrecognized S class date ) > > > > > > > My question is : how do I insert date in the oracle table DATEST ? > > > > SQL> desc DATEST; > > > > Name Type > > --...

..."") .Internal(seterrmessage(msg[1L])) if (!silent && identical(getOption("show.error.messages"), TRUE)) { cat(msg, file = stderr()) .Internal(printDeferredWarnings()) } invisible(structure(msg, class = "try-error"))}) 7: try({ ps <- oraPrepareStatement(con, statement, bind = NULL) rs <- oraExecStatement(ps, ora.buf.size = as(ora.buf.size, "integer"))}) 8: oraExecDirect(con, statement, ...) 9: oraQuickSQL(conn, statement, ...) 10: dbGetQuery(dotsConnection(), qry) -- This is the type of query (template) that crashes it, I know this...

...ora <- dbDriver("Oracle") > > con <- dbConnect(ora, user = "uuuuu", password = "pppp" , dbname = "dddd") > > dafra01 <- data.frame(N1=rep(c(10),10),C1=rep(c("11"),10),N2=rep(c(12),10),stringsAsFactors=FALSE) > > ps <- oraPrepareStatement(con=con, statement="insert into tmp_r (N1,C1,N2) values(:1,:2,:3)", bind= c("numeric","character","numeric")) > > oraDescribePreparedStatement(ps) <OraPreparedStatement:(24060,0,0)> Statement: insert into tmp_r (N1,C1,N2) values(:1,:2,:3) Has...

Hi All, This question was brought up some time ago but I never saw a reply so I'd like to bring it up again. When using ROracle package (version 0.5-5), I am unable to run any queries that are greater than 4000 characters in length. If I do, I get the following message: Error in oraPrepareStatement(con, statement, bind=NULL) : RS-DBI driver: (too long a statement -- it must has less than 4000 chars) I realize this is not a "bug", but simply a predefined limit that has been set. Can this string limit be increased? Based on the only email I saw on this issue I edited RS-Oracle.h to...