Extracting a CLOB field (XML) from an Oracle database

Mohammad_Danish · Post by **Mohammad_Danish** » Thu Sep 08, 2011 10:16 am

I am trying to extract two columns from Oracle database, one of which is a CLOB field storing XMLs. The task I want to accomplish is to get those XMLs and then map the elements of the XML to columns of a dataset. Please guide me how to design the job to accomplish this. Thanks in advance.
I am using Datastage 8.5.

arunkumarmm · Post by **arunkumarmm** » Thu Sep 08, 2011 1:21 pm

You can write it to a sequential file as is and create another job to treate it as XML input file and read the data.