PL/SQL procedure to move data from a complex xml file into tables
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.