PL/SQL (MOSC)

MOSC Banner

Is it possible to load XML file directly to an Oracle table by sql loader?

edited May 4, 2020 5:00AM in PL/SQL (MOSC) 4 commentsAnswered

Hello there,

We are working with a partner and they send the AP invoices to us in XML format.  We need to load the invoices to an temporary table or AP invoice interface table.  I have tried a few times but couldn't load the data directly into Oracle table.  So I just wonder if it is possible to do that.  The main problem right now is that XML file has some structure, such one header with a few lines, and SQL loader apparently can't handle it.  My question:

-  Is it a possible way to use SQL loader to handle XML files?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center