Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!prodigy.com!pd7cy2so!pd7cy1no!shaw.ca!border1.nntp.ash.giganews.com!border2.nntp.sjc.giganews.com!nntp.giganews.com!cyclone-sf.pbi.net!216.218.192.242!news.he.net!newsfeed1.easynews.com!easynews.com!easynews!elnk-pas-nf1!newsfeed.earthlink.net!cyclone.socal.rr.com!cyclone2.kc.rr.com!news2.kc.rr.com!twister.socal.rr.com.POSTED!53ab2750!not-for-mail From: Richard Kuhler Newsgroups: comp.databases.oracle.server Subject: Re: Oracle to XML Conversion Lines: 43 References: <5azTb.3240$a65.2100@twister.socal.rr.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.4) Gecko/20030624 Netscape/7.1 (ax) X-Accept-Language: en-us, en In-Reply-To: Message-ID: Date: Tue, 03 Feb 2004 00:48:12 GMT NNTP-Posting-Host: 204.210.41.27 X-Complaints-To: abuse@rr.com X-Trace: twister.socal.rr.com 1075769292 204.210.41.27 (Mon, 02 Feb 2004 16:48:12 PST) NNTP-Posting-Date: Mon, 02 Feb 2004 16:48:12 PST Organization: RoadRunner - West Xref: newssvr20.news.prodigy.com comp.databases.oracle.server:253509 The Legend wrote: > "Richard Kuhler" schreef in bericht > news:5azTb.3240$a65.2100@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