Loading from XML to Database

Hi All,

I want to load XML file data into database.

There is seperate XML file for each record (2000 record) and I want to load these records into a single Oracle database table

using SQL*Loader utility.

I tried to load these records by converting the xml file to text file. But In this case i have to convert each XML file to a text file so it does not suite my requirement.

My question are

1. Is it possible to load XML file data directly to oracle database table using "SQL*LOADER"?
2. If it is not what should be the convenient way to do it?
3. As there are 2000 records how to load these records in one request?

Plz. Help me out in this regard.

Thanks a lot.
Rakesh Patel Received on Sun Dec 07 2003 - 09:03:24 CET