Re: XML data files

From: DA Morgan <>
Date: Sat, 27 Nov 2004 19:34:39 -0800
Message-ID: <1101612784.173499_at_yasure>

Joyce Moore wrote:

> We're negotiating with an ASP that we need to exchange files with. They
> do all their data exchanges in XML format. Our database is 8.1.7, so
> whatever nice XML tools come in 9i aren't available to us.
> I'd appreciate advice on the best way to get the data from their XML
> files loaded into our relational tables. (This is just data, no need to
> store XML in the database.) From there, we can update our production
> tables selectively.
> If this is going to be really complicated, it may make more sense to
> have them produce a flat file we can read in with SQLloader; that would
> cost something for them to develop, but it might be worth it. Producing
> the XML files from our database to send to them shouldn't be hard. And
> all this must run on a Unix machine unattended.
> Any ideas appreciated.
> Joyce

And what's wrong with upgrading? Are you aware of the desupport notice Oracle issued on 8.1.7? Desupport begins in just one month.

Daniel A. Morgan
University of Washington
(replace 'x' with 'u' to respond)
Received on Sun Nov 28 2004 - 04:34:39 CET

Original text of this message