Re: XML data files

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
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)