Can any one give me some sample examples of Oracle to XML Conversion?
Thanks!
Richard Kuhler <noone_at_nowhere.com> wrote in message news:<gdCTb.3285$a65.925_at_twister.socal.rr.com>...
> The Legend wrote:
>
> > "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
>
> Standard CLOB 4 Gigabytes limit will apply. If you need a single XML
> file larger than that (assuming your OS can even support it) then you'll
> have to build it in sections using multiple calls.
Received on Wed Feb 04 2004 - 15:28:58 CST
