Re: ORU-10027 error caused by DBMS_OUTPUT calls in a function

SOLUTION DESCRIPTION:

To increase buffer, use set serveroutput command:

  SET SERVEROUTPUT ON SIZE buffer_size

  For example: SET SERVEROUTPUT ON SIZE 5000.

To verify the buffer size do SHOW SERVEROUTPUT.

For additional information on DBMS_OUTPUT refer to page 354 of ORACLE PL/SQL Programming.

Don Hall <dhall_at_twoil.com> wrote in message news:94E9080E958CB1D1.14C02A741AE4C65A.2993ADDE8223FF7F_at_lp.airnews.net...
> I received the following error when I converted a stored procedure (with
> DBMS_OUTPUT.PUT_LINE calls) to a function.
>
> ORA-20000: ORU-10027: buffer overflow, limit of 2000 bytes
> ORA-06512: at "SYS.DBMS_OUTPUT", line 106
> ORA-06512: at "SYS.DBMS_OUTPUT", line 65
> ORA-06512: at "TWS.PRIOR_HISTF", line 49
> ORA-06512: at line 1
>
> I understand these calls are inappropriate in a function...and have
> been removed...however, some questions did come to mind...
> Where are these ORU-XXXXX messages documented?
> Would adding the call DBMS_OUTPUT.ENABLE(100000) resolve this error?
> Where was the output going? Was is retrievable from some buffer or
> other location?
> Why don't you see the output when the function is run in SqlPlus (as
> from a stored procedure) with Set Serveroutput On?
>
> Thanks for your assistance.
> Don Hall
> Transworld Oil USA
>
>
Received on Fri Jul 16 1999 - 04:57:09 CDT