Page 1 of 1

reading CLOB datatype from Oracle.

Posted: Tue Sep 29, 2009 11:23 am
by mekrreddy
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.

Posted: Tue Sep 29, 2009 11:26 am
by chulett
Searching would also reveal discussions of "workarounds" for this.

Posted: Tue Sep 29, 2009 12:24 pm
by mekrreddy
Can we achieve this in SERVER job? somehow??

Posted: Tue Sep 29, 2009 12:48 pm
by arnabdey
Hi.. Just a hit and trial... Please push all the CLOB fields at the end of the column definitions and try.....

Posted: Tue Sep 29, 2009 1:31 pm
by Nagaraj
And also keep the column size as nothing, it should work fine.