0 Replies Latest reply on Jun 21, 2011 1:36 AM by pjsiong-JavaNet

    Save clob data in file

      I try to save the content of a clob field into a file using the sql below:

      set heading off
      set echo off
      set termout off
      set verify off
      set pagesize 0
      set linesize 1000
      set trimspool on
      set long 200000
      set feedback off
      spool filename.txt
      select clob_data('TEST') from dual;
      spool off

      but file saved will become 80 characters per line even thought I had set linesize 1000,
      anyone know what could be the cause of this?