I have stored my xml in a table. Select and insert in a new table works.
I save the xml file with sqloader as xmltype as HUGECLOB. I can select with xpath the data and insert it in a new table.
My Table structure is:
MAINPART | MAINPART2 | MAINPART3 | MAINPARTEXTENSION1 | MAINPARTEXTENSION2 | MAINPARTEXTENSION3 | MAINPARTEXTENSION4
I can map everything from the xml file except the mainpartextension. The select gives me a singleton error. How can I handle with Select or PL/SQL with a Loop or another xpath xpression to laod the xml tag MAINPARTEXTENSION into MAINPARTEXTENSION1 , MAINPARTEXTENSION2, MAINPARTEXTENSION3,....