Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to parse/extract XML from clob field using ODI

810904Nov 5 2010

Hi,

I am very new to ODI. I have an oracle table which has clob field. This clob field contains xml. I would like to parse this xml and convert it to oracle table. Means I would like to make all the tags of xml as oracle table columns.

I have created a PL/SQL procedure and used XMLTABLE function and I have achieved my goal. The same this I am trying to do with ODI. Since I am new to ODI so any help is appreciated.

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 3 2010

Added on Nov 5 2010

#business-intelligence-applications, #data-integrator, #system-management-and-integration

0 comments

510 views