OraFAQ Forum: Client Tools » Spool 32k+ Clob to a flat file (2 Merged)

Home » Other » Client Tools » Spool 32k+ Clob to a flat file (2 Merged)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Spool 32k+ Clob to a flat file (2 Merged) [message #590213]

Mon, 15 July 2013 18:53

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.

Report message to a moderator