04-27-2006, 12:28 AM
does kettle support transfering BLOB and CLOB types in oracle. I saw kettle recognize them as strings.
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.