Spooling data to CSV truncates

Posted by Steve on Stack Overflow See other posts from Stack Overflow or by Steve
Published on 2010-04-14T14:40:43Z Indexed on 2010/04/14 14:43 UTC
Read the original article Hit count: 309

Filed under:
|
|
|

Hi,

I am using the below script to output data to a csv file:

set heading off
set linesize 10000
set pagesize 0
set echo off
set verify off

spool D:\OVERNIGHT\TEMP_FILES\PFRA_DETAIL_VIXEN_OUTPUT.txt


SELECT
TRIM(T4.S_ORG_ID)||','||
TRIM(T4.NAME)||','||
TRIM(T3.CREATION_TIME)||','||
TRIM(T5.X_HOUSE_NUMBER)||','||
TRIM(T5.X_FLAT_NUMBER)||','||
TRIM(T5.ADDRESS)||','||
TRIM(T5.CITY)||','||
TRIM(T5.ZIPCODE)||','||
TRIM(T3.NOTES)
FROM TABLE_CASE T1
INNER JOIN TABLE_QUEUE T2 ON T1.CASE_CURRQ2QUEUE = T2.OBJID
INNER JOIN TABLE_PHONE_LOG T3 ON T1.OBJID = T3.CASE_PHONE2CASE
INNER JOIN TABLE_BUS_ORG T4 ON T1.X_CASE2X_BUS_ORG = T4.OBJID
INNER JOIN TABLE_ADDRESS T5 ON T1.CASE2ADDRESS = T5.OBJID
WHERE case_currq2queue IN(422);

/


spool off;
exit;

However the data is being truncated to 80 characters. The t3.notes field is in CLOB format. Does anyone know how I can spool this out to csv? I only have access to SQL*Plus.

Thanks in advance, Steve

© Stack Overflow or respective owner

Related posts about Oracle

Related posts about csv