PDA

View Full Version : transfering oracle BLOB types



giyoram
04-27-2006, 12:28 AM
does kettle support transfering BLOB and CLOB types in oracle. I saw kettle recognize them as strings.


Thanks

jbleuel
04-27-2006, 04:00 AM
CLOB is supported but not BLOB types. A CLOB is read in as a string and marked with a length of 9999999.


There is already a change request: Supporting Large Objects (LOBs) http://www.javaforge.com/proj/tracker/itemDetails.do?task_id=1644&navigation=true
and a solution proposal from Matt.



HTH,
Jens

kettle_anonymous
04-27-2006, 05:31 AM
Thanks