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