Re: Oracle to XML Conversion

From: David Penney <anon_at_noone.com>
Date: Sun, 8 Feb 2004 13:08:52 +0000 (UTC)
Message-ID: <c05cd4$2ae$1@sparta.btinternet.com>

Hi
there is XML support in Oracle, beyond that if you want a graphical tool, greater productivity & maintenance take a look at MetaMatrix,we have a superb XML-relatonal mapping capability with execution against multiple,diverse sources ,including Oracle.

Additionally your app can connect directly to our server using ODBC/.JDBC/JMS or via SOAP as a webservice. If you have a simple XML document & this is your only need then we will be overkill for you.
Regards
David Penney -MetaMatrix
http://www.metamatrix.com

"Hari Om" <hari_om_at_hotmail.com> wrote in message news:d1d5ebe4.0402021305.3b5285c5_at_posting.google.com...
> I am using Oracle 9.2.0.4 on IBM AIX 5.1L.
> I have a instance named "GATES" which has around 100 tables.
>
> I would like to extract some data from these tables and make an XML
> file out of it. I then have to UPLOAD this XML File to other
> Applicaiton.(this other application is designed to accept only XML
> File formats)
>
> My question is what is the best possible way to move data from
> Relational Tables to and XML File? Any related information on this is
> appreciated.
>
> THANKS!
Received on Sun Feb 08 2004 - 07:08:52 CST