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

      Thanks.

      Dana