Displaying 1 result from an estimated 1 matches for "clob_col".
2011 Dec 14
0
Reading Oracle SQL Developer BLOB/CLOB files into R (Packages: DBI, foreign, RODBC, ROracle)
...ble because it did not return error when
reading from BLOB column, but 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...