Hi,I have scenario where I need to upload data from XML file into a table. XML file is a predifined format. How can I achieve this, Is there any built in package similar to SQL loader to extract required field values and upload them into table.Pls suggestThanks

Interview Candidate
Jun 19th, 2006
2
1424

Showing Answers 1 - 2 of 2 Answers

Elango

Jun 23rd, 2006

Hi,
There are couple of ways to do it other than loader.
1) You can load the file into a clob and make use of the sys.xmlparser and sys.xslprocessor packages to load it to files.
2) You can load the file into a clob and make use of the dbms_xmlsave package to load it. The above one allows you to customize and load whereas here the available functionality is minimal.
Regards,
Elango.

Guest

Apr 12th, 2007

hi,If you are using SQL server then you have an in-built option in the SQL Server itself. You can read xml in db through stored procedures.sp_xml_preparedocument - search for this option in sql server.