[resolved] How to Read CLOB object

One Star

[resolved] How to Read CLOB object

HI,
How to read CLOB object using Talend which contains XML data in it.
Any control that takes CLOB data and represent its content as XML.
Thanks
One Star

Re: [resolved] How to Read CLOB object

If you are working with Oracle, you can use tOracleInput to read the CLOB column (Column Type can be set as Object). We can then use a Java component to get the InputStream from the clob instance. This stream can be used in a tFileInputXML to read the XML contect. tJava_3 is introduced to close the input stream after processing each row. Attaching screen shots.
Regards,
Abhi
Seventeen Stars

Re: [resolved] How to Read CLOB object

hi all,
nice shoot iterator Smiley Happy
laurent
One Star

Re: [resolved] How to Read CLOB object

Thanks Abhi..........I appreciate your help.
Community Manager

Re: [resolved] How to Read CLOB object

Hi Iterator
Good example!
Best regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
Four Stars svs
Four Stars

Re: [resolved] How to Read CLOB object

Is this a serious community?  I mean you appear to have lost the screenshots which would be really important in relaying this information