Displaying 4 results from an estimated 4 matches for "oraexecstatement".
2004 Mar 10
2
Inserting Date Field into Oracle table using ROracle
...ot;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 driver: (ORA-01861: literal does not match format string )
Thanks for your help in advance,
Swami
(smalladi at lexgen.com)
----------------------------- Correspondence with David James
-----------------------
Dear David,
Thanks for your kind reply. I did what yo...
2009 Mar 27
0
consistent segfaults in ROracle with one of the databases
...also a type of query that crashes
it:
*** caught segfault ***
address 0x1, cause 'memory not mapped'
Traceback:
1: .Call("RS_Ora_exec", ps = as(ps, "integer"), data = data,
data.classes = df.classes, buf.size = as.integer(ora.buf.size),
PACKAGE = .OraPkgName)
2: oraExecStatement(ps, ora.buf.size = as(ora.buf.size, "integer"))
3: doTryCatch(return(expr), name, parentenv, handler)
4: tryCatchOne(expr, names, parentenv, handlers[[1L]])
5: tryCatchList(expr, classes, parentenv, handlers)
6: tryCatch(expr, error = function(e) { call <- conditionCall(e)
if (!...
2009 Feb 09
0
ROracle - ORA-02005: implicit (-1) length not valid for this bind or define datatype
...experienced this behaviour with
ROracle package. I'm attaching information to reproduce the issue.
Bug maybe?
Thank you very much for your attention.
Ramon.
##################################################################
##################################################################
oraExecStatement BUG : RS-DBI driver: (ORA-02005: implicit (-1)
length not valid for this bind or define datatype
##################################################################
##################################################################
> library(ROracle)
Loading required package: DBI
>
>...
2011 Dec 14
0
Reading Oracle SQL Developer BLOB/CLOB files into R (Packages: DBI, foreign, RODBC, ROracle)
...ut instead it converted the column into
String(255) (This is what we think it did based on following message)
----------------------------------------------------------------------------
> rs <- dbSendQuery(con, "SELECT CLOB_COL from R_BLOB_TEST where ROW_ID=1")
Warning message:
In oraExecStatement(ps, ora.buf.size = as.integer(ora.buf.size)) :
RS-DBI driver warning: (unkown ORA type 112 (extracted as STRING(255)))
The Ora type 113 and 112 seem to be pointing to CLOB and BLOB objects as
being unrecognised. Is there anyway to fix this?
So far our attempts on the R side have not been good b...