Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!nx01.iad01.newshosting.com!newshosting.com!216.196.98.140.MISMATCH!border1.nntp.dca.giganews.com!nntp.giganews.com!postnews.google.com!news4.google.com!sn-xit-04!sn-xit-12!sn-xit-09!sn-post-01!supernews.com!corp.supernews.com!not-for-mail From: DA Morgan Newsgroups: comp.databases.oracle.misc Subject: Re: CLOB to file Date: Mon, 12 Dec 2005 08:49:29 -0800 Organization: Ye 'Ol Disorganized NNTPCache groupie Message-ID: <1134406165.311601@jetspin.drizzle.com> User-Agent: Mozilla Thunderbird 1.0.6 (Windows/20050716) X-Accept-Language: en-us, en MIME-Version: 1.0 References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Cache-Post-Path: jetspin.drizzle.com!unknown@oracle.advtechserv.com X-Cache: nntpcache 3.0.1 (see http://www.nntpcache.org/) X-Complaints-To: abuse@supernews.com Lines: 19 Xref: dp-news.maxwell.syr.edu comp.databases.oracle.misc:123812 tom wrote: > he > hot to store CLOB data to file using enterprise manager or SQL plus. When I > trie save report to file it stores only 1000 chars > I have Oracle 10; > > t. www.psoug.org click on Morgan's Library click on UTL_FILE scroll down to: Extract BLOB demo It will work with CLOBs too. -- Daniel A. Morgan http://www.psoug.org damorgan@x.washington.edu (replace x with u to respond)