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: 25578
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: ORA-12545 error in PL/SQL developer in windows 7
Goto Forum:
  


Current Time: Wed Aug 23 03:15:10 CDT 2017

Total time taken to generate the page: 0.01735 seconds