Skip to Main Content

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!

Extract data from BLOB (XML) and load it to Oracle table in ODI

3173245Jun 15 2020 — edited Jun 15 2020

Hi All,

we have an requirement to extract XML data from an BLOB datatype and load in to Oracle table through ODI.

Kindly let me know if there is an way to convert this XML BLOB data into tables structure

Source BLOB data : Attached

Untitled.png

Thanks. :-)

Comments
Post Details