Load XML into relational stucture

From: Karsten Weikop <oraclel_at_weikop.com>
Date: Mon, 24 Jan 2005 14:13:07 -0500 (EST)
Message-ID: <000001c4fc1b$64fd3990$6401a8c0@KW>

Hi all

I need to load XML documents (invoice + lines) into the database and store then in a relational structure (not object-oriented) in the Oracle Database.

We have a requirement to load 20+ documents per second. Whenever generated by the source component, the documents are copied to a directory and we need to write/use a tool which loads the XML document.

The tool will not be executed on the same server as the database.

What is your recommandations for selecting a tool for this task?

We are using Solaris and RDBMS 9.2.0.x.

/karsten

--

http://www.freelists.org/webpage/oracle-l
--

http://www.freelists.org/webpage/oracle-l Received on Mon Jan 24 2005 - 14:14:59 CST