Let us say we want to import an XML file as shown in the next picture. This XML file was generated by exporting a table from an MS Access application.
Simplifying the test further
The MS Access created file has Microsoft Namespace references, details of columns, and so forth. In this format the Load into Oracle will fail. From experience the XML document loading error messages in Oracle 10G XE do not give much help to the user. This help would have been very useful as the user does not know what to do next. Hence for this tutorial the following simplified procedure was used.
The idea is to create a table, export it as an XML document and try to load it to the same table with different data. The rest of the steps do show that this at least succeeds.