PL/SQL (MOSC)

MOSC Banner

PL/SQL procedure to move data from a complex xml file into tables

in PL/SQL (MOSC) 1 commentAnswered

Hi,

I have a complex XML file, of which I need to move the data to my relational tables in oracle. I added an example of the file.

I insert the data in a table with only 1 column of xmltype.

Then I need to extract all data to be able to put them in my tables.

I wanted to do it this way :

but then I get following error :

It works for x1 and x2, but when I add x3, i get this error. And I still have to a one more level.

So I need to do it in another way.

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