Hi All,
I am currently trying to select all of the date in a table and spool it to a csv file. The issue is that one of the fields is a clob. When I run it I only get the first 80 characters of the record. When I take out the CLOB I get all the other fields (with the clob it cuts off after about 6 fields.) I know CLOBs can be tricky to work with, but I hope the solution is simple. Here's my SQL:

set pagesize 0
set termout off
set trimspool on
set linesize 32767
set feedback off
set trimout on
set underline off
set time off
set timing off
SET NEWPAGE 0
SET SPACE 0
SET ECHO OFF
SET VERIFY OFF
SET HEADING OFF
SET MARKUP HTML OFF
SET tab off

/* Data for Extract */

spool foo.csv
select
',"'||TRIM(E_PARTNER_KEY)||'",'||
'"'||TRIM(E_NAME)||'",'||
'"'||TRIM(E_WEBSITE)||'",'||
'"'||TRIM(E_INDUSTRY)||'",'||
'"'||TRIM(C_PARTNER_KEY)||'",'||
'"'||TRIM(C_USERNAME)||'",'||
'"'||TRIM(C_PASSWORD)||'",'||
'"'||TRIM(C_CONTACTINFOACCESS)||'",'||
'"'||TRIM(C_FIRSTNAME)||'",'||
'"'||TRIM(C_LASTNAME)||'",'||
'"'||TRIM(C_EMAIL)||'",'||
'"'||TRIM(J_PARTNER_KEY)||'",'||
'"'||TRIM(J_TITLE)||'",'||
'"'||TRIM(J_OPPORTUNITY_TYPE)||'",'||
J_IS_FULLTIME||','||
'"'||TRIM(J_TRACK_DECISIONS)||'",'||
to_char(J_APPLY_STARTDATE, 'MM/DD/YY' )||','||
to_char(J_APPLY_ENDDATE, 'MM/DD/YY' )||','||
'"'||TRIM(J_COMPENSATION_DETAILS)||'",'||
'"'||TRIM(J_SPECIAL_INSTRUCTIONS_TYPE)||'",'||
'"'||TRIM(J_SPECIAL_INSTRUCTIONS)||'",'||
'"'||TRIM(J_ADDITIONAL_INSTRUCTIONS)||'",'||
J_TRACK_APPLICATIONS||','||
to_char(J_SEARCHABLE_BEGINDT, 'MM/DD/YY' )||','||
to_char(J_INACTIVATION_DT, 'MM/DD/YY' )||','||
J_IS_DEPLOYED_TO_ALL||','||
'"'||TRIM(J_CITY)||'",'||
'"'||TRIM(J_STATE)||'",'||
'"'||TRIM(J_COUNTRY)||'",'||'"',
/* Formatting of this column is off due to SQL-PLUS limitations, there is a large amount of whitespace between the previous column and this one. This field also can't be concatenated with the previous since it is a CLOB column. So for now, we have to live with a large amount of spaces embedded between fields. Also, the trailing quote at the end of the line is not showing up, there appears to be a problem with Concatenating text to the tail end of a CLOB. So, for the short term we are appending a quote to the end of the line in post-processing
*/
',"'||substr(J_DESCRIPTION,1,DBMS_LOB.GETLENGTH(J_DESCRIPTION))||'"'
from FOO_OUT
/

spool off