DevOps, CI/CD and Automation

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!

What is the best way to load XML data from a file into Oracle tables? I do not have any XML Schema s

User_BPLELOct 11 2016 — edited Dec 9 2016

Hi All,

I have an external data file with XML data. What is the best way to load this data into custom staging tables in Oracle database 11g? I do not have any XML Schema setup. The XML data is nested in structure.

I have come across articles suggesting using 'ExtractValue', DBMS_XMLDOM, DBMS_XMLSTORE etc, but they all probably need to have XML Schema setup ? Is there a solution for non- XML Schema setup ?

Kindly advise.

Thanks

-Madhuri

This post has been answered by odie_63 on Oct 15 2016

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 6 2017

Added on Oct 11 2016

#pl-sql-xml-programming, #xml

20 comments

1,566 views