This discussion is archived
7 Replies Latest reply: Aug 7, 2013 10:53 PM by 84b09b47-0add-4854-b184-296b3903b009 RSS

Scirpt output of CLOBs are truncated

Juergen Newbie
Currently Being Moderated

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


  • Correct Answers - 10 points
  • Helpful Answers - 5 points