7 Replies Latest reply: Aug 8, 2013 12:53 AM by 84b09b47-0add-4854-b184-296b3903b009 RSS

    Scirpt output of CLOBs are truncated

    Juergen
      Hi,

      at the end of the day I want to spool the clob content of a table in a file.

      The spooling itself is working but even without spooling when I run e. g. select my_clob from table where id = 4711 as a script (F5) I only get 3 lines of the output. The same with spooling on.

      Is there any setting that change that behaviour? Or any other workaround? The output of a varchar2(4000) column works fine, but I have some content larger then 4000.

      Thanks, Juergen