transfering oracle BLOB types

[giyoram]

does kettle support transfering BLOB and CLOB types in oracle. I saw kettle recognize them as strings.


Thanks

[jbleuel]

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]

Thanks