0 Replies Latest reply: Jun 20, 2011 6:36 PM by pj*433620*ng RSS

    Save clob data in file

    pj*433620*ng
      Hi,
      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?

      Thanks

      Vincent