Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to set linesize for CLOB objects in i*sql

501765Mar 28 2006
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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 25 2006
Added on Mar 28 2006
0 comments
595 views