Re: CLOB to file via UTL_FILE
From: Mladen Gogala <mgogala_at_yahoo.com>
Date: Tue, 23 Dec 2008 23:03:20 +0000 (UTC)
Message-ID: <girqno$sbe$1@ss408.t-com.hr>
Date: Tue, 23 Dec 2008 23:03:20 +0000 (UTC)
Message-ID: <girqno$sbe$1@ss408.t-com.hr>
On Tue, 23 Dec 2008 13:30:57 -0800, webtourist wrote:
> I have large CLOB (XML) (way bigger than 32K) data that has NO
> LINEBREAK/NL.....
>
> I want to write the CLOBs to files.
> Using UTL_FILE...is there anyway to avoid newline --- so that the file
> size = LOB length ?
>
> If not, is there another option ?
>
> thanks
DBMS_LOB package can do that.
-- http://mgogala.freehostia.comReceived on Tue Dec 23 2008 - 17:03:20 CST