reading CLOB datatype from Oracle.

mekrreddy · Post by **mekrreddy** » Tue Sep 29, 2009 11:23 am

Hello,
We have ClOB datatype in oracle in one of our jobs , when i try to read, i am getting error, PEEK_IDENT by searching here i found DS does not support CLOB datatype, i dd not find any workaround, please kindly give your thoughts on this.

Thanks alot..
Reddy.

chulett · Post by **chulett** » Tue Sep 29, 2009 11:26 am

Searching would also reveal discussions of "workarounds" for this.

mekrreddy · Post by **mekrreddy** » Tue Sep 29, 2009 12:24 pm

Can we achieve this in SERVER job? somehow??

arnabdey · Post by **arnabdey** » Tue Sep 29, 2009 12:48 pm

Hi.. Just a hit and trial... Please push all the CLOB fields at the end of the column definitions and try.....

Nagaraj · Post by **Nagaraj** » Tue Sep 29, 2009 1:31 pm

And also keep the column size as nothing, it should work fine.