This discussion is archived
6 Replies Latest reply: May 13, 2009 7:22 AM by Dana N RSS

SQL Developer 1.5.3: SIZE honored in SET SERVEROUTPUT ON SIZE <nbr> ?

Dana N Newbie
Currently Being Moderated
I'm running some PL/SQL in SQL Developer 1.5.3 and am getting some buffer overflow error messages while using dbms_output.put_line.

At the top of my script, I've put:

set serveroutput on size 100000

But get these errors:

ORA-20000: ORU-10027: buffer overflow, limit of 20000 bytes
ORA-06512: at "SYS.DBMS_OUTPUT", line 35
ORA-06512: at "SYS.DBMS_OUTPUT", line 198
ORA-06512: at "SYS.DBMS_OUTPUT", line 139
ORA-06512: at line 28

Does SQL Developer 1.5.3 not, in fact, honor the SIZE portion of SET SERVEROUTPUT ON? If not, can this be set in the preferences? (couldn't find it).




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