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.
--
Richard Kuhler
Received on Mon Feb 02 2004 - 18:48:12 CST
