This discussion is archived
11 Replies Latest reply: Dec 14, 2012 4:54 AM by Fran RSS

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

846231 Newbie
Currently Being Moderated
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

Legend

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