6 Replies Latest reply: May 13, 2009 9:22 AM by Dana N RSS

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

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