Re: Oracle to XML Conversion

"Richard Kuhler" <noone_at_nowhere.com> schreef in bericht news:5azTb.3240$a65.2100_at_twister.socal.rr.com...
> Hari Om wrote:
>
> > 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!
>
> One option is to use the built in XML support. Take a look at
> DBMS_XLMGEN. The GETXML function will accept a reference cursor or
> query and return the XML as a CLOB.
>
> --
> Richard Kuhler
>

Is this function hold to a maximum amount of data to query using a clob ?

Ed Received on Mon Feb 02 2004 - 18:06:25 CST