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:



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