I have a very simple data flow - two inputs, one output, one query transform. Input and output are Oracle tables. The output is a Template table.
Three columns are going from CLOB to CLOB. They are declared Long in DI. All three are getting truncated at 4000 characters.
I have NOT checked the “Import unsupported data types as varchar”
I am using DI 11.7 and Oracle 10g
chrisj (BOB member since 2009-07-14)
There are some issues with this datatypes @ Oracle and 3rd party products.
I tried to do an insert select statement with clob fields in both tables and they are running fine even with strings with 4000+ chars (at database).
So i think you can do something like this.
Try to cheat on DI datatypes importing the table with varchar(4000) in both source & destination. Do your query in a way that it gets pushed down as an insert select statement. Then change Oracle tables to CLOB without reimporting them and run your DF, as long as you don’t make function calls, filter, distinct or group by on CLOB fields in your statement, i think it should work.
Astro 
(BOB member since 2007-02-15)