Is it possible to load XML file directly to an Oracle table by sql loader?
Hello there,
We are working with a partner and they send the AP invoices to us in XML format. We need to load the invoices to an temporary table or AP invoice interface table. I have tried a few times but couldn't load the data directly into Oracle table. So I just wonder if it is possible to do that. The main problem right now is that XML file has some structure, such one header with a few lines, and SQL loader apparently can't handle it. My question:
- Is it a possible way to use SQL loader to handle XML files?