We have an import script running on a Unix server, using SQL*Loader to import files with information into a database table in Oracle 9. Now we want to be able to import XML formatted files instead of "text" files. Can we still use SQL*Loader to do this or should we use a different tool.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
We are using Oracle 9, should that be a difference?
We don't want XML in the database, just normal number, varchar datatypes as they are today. What should the steps be to be able to use SQL*Loader importing the XML formatted files into a database table?