SQL & PL/SQL

Hello Gurus,

i have a typical problem

i am constructing a query in FORM and writing SQLPLUS script into a .SQL file. file will contain final data like below..

set linesize 90
set pagesize 0
set echo off
set verify off
set termout off
set feedback off
set trimspool on
set escape '^'
spool D:\10GAPPServerappln\xxx\TEMPREP\ADA39057.sql;
set linesize 229
select ' IQIS# ,Cust Complaint Short Txt ,CD Short Txt ' from dual;
set linesize 129
select a||','||b||','||c||d from table;
/
spool off;
exit;

After this By using HOST command i will execute the above .sql script and will write the output to text file.

But problem is when i have clob column in any one of concatenated columns in query (a or b or c) then i am getting the error "Ora-01489: result of string concatenation is too long".

pls suggest me how to overcome this problem..