Home » Other » Client Tools » Spool 32k+ Clob to a flat file (2 Merged)
Spool 32k+ Clob to a flat file (2 Merged) [message #590213] Mon, 15 July 2013 18:53 Go to next message
bearjoeyin
Messages: 1
Registered: July 2013
Junior Member
Hi,

I would like to spool a clob column to a flag file, however some of the clob are greater than 32k, and I have to have the same record in a single line in the file. Is there any way to achieve this through spooling?

set heading off
set feedback off
set term off
set long 1000000
set longchunksize 500000
set line 32767
set trimspool on
set pagesize 50000
spool file.txt
@--this is my select statement.
spool off
exit

Thanks for reading.
Re: Spool 32k+ Clob to a flat file [message #590215 is a reply to message #590213] Mon, 15 July 2013 18:57 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
> Is there any way to achieve this through spooling?
no

http://www.lmgtfy.com/?q=oracle+clob+to+file
Previous Topic: ORA-01034:Oracle not available
Next Topic: Oracle xsl fo reports
Goto Forum:
  


Current Time: Thu Mar 28 10:21:18 CDT 2024