Hi,

I'm using Clob data field in my table.I want to extract data from that field in the data file.
I have created one sql with set parameters and spool the result in dat file.
when i tried fetching data more than 32K,the lines get added in multiple lines in the dat file.The maximum length of data need to be fetched is arnd 2,00,000.
I want the data to be extracted in the same line.
My sql code is like:

set verify off
set newpage 0
set space 0
set arraysize 1
set linesize 32000
set pagesize 0
set echo off
set feedback off
set heading off
set recsep off
set com v7
set term off

SET MAXDATA 190080
SET LONG 190080
set trimspool on
spool DIR/test_ext.dat

select
tab_ext_num,
tab_ext_data
from tab_ext;

spool off;
exit 0;

when i tried giving set linesize as 200000 it is throwing error as maximum length out of bounds.

Please tell me how to proceed with this.

Thanks,
Ramya.