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).

Thanks.

Dana

Legend

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