I need to read a clob column and load it to Target Table.
I am using Oracle Stage and used the Datatype as LongVarChar.
When i gave empty string to Length i was able to read the CLOB column and load it successfully to a file.
But when i tried to replace the file to the Target table, i am not able to load the table. Even in the target i gave Empty string to Length.
Following is the error i got from Director.,
Code: Select all
Inserted value too large for column, row rejected.
Cheers!!!!!