Home » SQL & PL/SQL » 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: 22926
Registered: January 2009
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: Fri Oct 31 02:20:37 CDT 2014

Total time taken to generate the page: 0.11328 seconds