Skip to Main Content

APEX

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

SQL Workshop > Utilities > Data Load > XML received LPX-00222 error

sect55Sep 25 2018 — edited Sep 26 2018

Hi all,

APEX 5.1

Oracle 11g Rel 2

I tried to load data from an XML file to my Oracle table and I received the following error:

ORA-31011: XML parsing failed ORA-19202: Error occurred in XML processing LPX-00222: error received from SAX callback function

Error loading XML.

The Oracle table references all the columns in the XML file but each row of the XML file does not necessarily contain all the columns.

For example, the table is defined as follows:

pastedImage_7.png

pastedImage_8.png

pastedImage_9.png

Not all the rows contain all the columns. See attachment (sub_c_row_example.txt) for an example of one row.

I can not define all the columns in each row. The XML file is exported from a Microsoft Access table. Also, there are thousands of rows.

How can successfully import the rows into the Oracle table?

Thank you,

Robert

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Oct 24 2018
Added on Sep 25 2018
3 comments
385 views