search for: orapreparedstatement

Displaying 2 results from an estimated 2 matches for "orapreparedstatement".

2009 Feb 09
0
ROracle - ORA-02005: implicit (-1) length not valid for this bind or define datatype
..."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 completed? no Affected rows: -1 Rows fetched: -1 > oraPreparedStatementInfo(ps) $statement [1] "insert into tmp_r (N1,C1,N2) values(:1,:2,:3)" $isSelect [1] 0 $rowsAffected [1] -1 $rowCount [1] -1 $...
2004 Mar 10
2
Inserting Date Field into Oracle table using ROracle
Hello, Attached is a mail regarding question how to insert Date field using ROracle package. I am stuck 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