Displaying 1 result from an estimated 1 matches for "jdomenge_test".
2009 Jun 04
0
ROracle: cannot insert several columns
...ble
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 123 NA
3 456 NA
so the 2 new rows were appended, except the values in the second
column were seemingly not read...
the same happens with dbWriteTable:
> dbWriteTable(conn,"mytable",df,append=T,...