Skip to Main Content

SQL & PL/SQL

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!

Error LPX-00245: extra data after end of document

daphne_121Oct 11 2022 — edited Oct 14 2022

Hello everyone,
I have a problem inserting xml file. I have to create directory and passing from it. But my xml file like this:

<?xml version = "1.0" encoding="utf-8"?>
<a> <date>20221011</date></a>
<b>
<b1>
<field1>092010</field1>
</b1>
<b1>
<field1>093456</field1>
</b1>
....
</b>

I want to import <field1>'s data into my table, not <a>'s. But of course there's an error for multiple roots. I want to remove or delete <a> tag or add <a> and <b> tags into new root.
What should I do?
Thanks,
Daphne.

This post has been answered by daphne_121 on Oct 13 2022
Jump to Answer
Comments
Post Details
Added on Oct 11 2022
11 comments
2,298 views