Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> ORU-10027 error caused by DBMS_OUTPUT calls in a function

ORU-10027 error caused by DBMS_OUTPUT calls in a function

From: Don Hall <dhall_at_twoil.com>
Date: Tue, 13 Jul 1999 20:15:44 +0000
Message-ID: <94E9080E958CB1D1.14C02A741AE4C65A.2993ADDE8223FF7F@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 Tue Jul 13 1999 - 15:15:44 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US