Re: CLOB to file

From: DA Morgan <damorgan_at_psoug.org>
Date: Mon, 12 Dec 2005 08:49:29 -0800
Message-ID: <1134406165.311601@jetspin.drizzle.com>

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_at_x.washington.edu
(replace x with u to respond)

Received on Mon Dec 12 2005 - 10:49:29 CST