Re: XML data files

"Joyce Moore" <jm5h_at_andrew.cmu.edu> wrote in message news:14EDE4982372774B0DCF1566_at_JMOORE.AS.cmu.edu...
> 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

First suggestion is to get:

"Building Oracle XML Applications" from O'Reilly by Steve Muench - this will show you how to load xml files into your database Received on Thu Nov 25 2004 - 15:01:29 CET