11 Replies Latest reply: Dec 14, 2012 6:54 AM by Fran RSS

    ORA-20000: ORU-10027: buffer overflow, limit of 20000 bytes

    846231
      Hi All,

      11.1.0


      I am running a procedure using SqlDeveloper window. But i got error:
      ORA-20000: ORU-10027: buffer overflow, limit of 20000 bytes
      ORA-06512: at "SYS.DBMS_OUTPUT", line 32
      ORA-06512: at "SYS.DBMS_OUTPUT", line 97
      ORA-06512: at "SYS.DBMS_OUTPUT", line 112
      ORA-06512: at "MDC_SC.UPDATE_FWCCB_SP", line 26
      ORA-06512: at line 2
      But if I run the procedure at command line, it does not get error :(

      for example:

      sqlplus scott/tiger

      sql> exec proc1;

      ...Displays output messages...

      PL/SQL procedure successfully completed.


      But the ORA-20000 does not show.


      Please help,


      Thanks a lot,
      Kinz