Re: Direct Import of XML file

There is: XML-SQL (Java) Utility. See the Application Developer's Guide - XML documentation for details of setting up and configuring CLASSPATHs, connections etc..

Basically you write your XSL Transformation to convert your source XML file into a <ROWSET>/<ROW> format and an XSQL page which tells the XML-SQL utility what to do (I.e. xsql:insert-request connect="named database connection, defined in XSQLConfig.xml").

• Bill.

At 06:48 21/03/02 -0800, you wrote:

>Hi list,
>
>Is there any tool in Oracle to import a xml-file direct to a database table?
>
>TIA
>
>Volker Schoen
>E-Mail: <mailto:v.schoen_at_inplan.de>v.schoen_at_inplan.de
>http://www.inplan.de

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Bill Buchan
  INET: wbuchan_at_uk.intasys.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).