Loading XML file onto a Oracle Db

[IMAUser]

Hi,
I m working on a Oracle 9.2 db.

I need to load an xml file onto a table using sql*Loader. Any ideas how I could do this. Or are there any other ways to do it which do not involve Java or other scripting languages.

Thanks,

 

[HimanB]

Hi,
You may simply put the contents of the XML file directly into a LOB column.
Make use of UTL_FILE to read the file.

Regards
Himanshu

 

[IMAUser]

Thanks Himanshu for the response.

But I need to load it into relational tables and I think for that I'll have to use SQL*Loader. Any idea how I can load it into relational tables useing SQL*Loader.

 

[IMAUser]

Any one ??

 

[HimanB]

Hi,
I think usage of SQL*Loader will not be possible if you intend to load the Data of each node into separate columns.

In order to achive this you need to make use of DBDOM package.
Please refer to thread759-821859

HTH
Regards
Himanshu

 

[taupirho]

If you have access to Visual Basic check out my article at

http://the-big-o.port5.com/article65.shtml

for a way to do what you want