ORU-10027 
Author Message
 ORU-10027
Hi there,

   When I called a PL/SQL procedure, it gave me the following error:

ERROR at line 1:
ORA-20000: ORU-10027: buffer overflow, limit of 1000000 bytes

   Could someone tell me how I could have this problem fixed?  I would
really appreciate it.

Thanks in advance.

Gloria



Wed, 24 Mar 2004 04:13:12 GMT
 ORU-10027

Quote:

> Hi there,

>    When I called a PL/SQL procedure, it gave me the following error:

> ERROR at line 1:
> ORA-20000: ORU-10027: buffer overflow, limit of 1000000 bytes

>    Could someone tell me how I could have this problem fixed?  I would
> really appreciate it.

> Thanks in advance.

> Gloria

You are trying to write too much data via DBMS_OUTPUT.  From the docs...

DBMS_OUTPUT

The DBMS_OUTPUT package enables you to send messages from stored
procedures, packages, and triggers.

The PUT and PUT_LINE procedures in this package enable you to place
information in a buffer that can be read by another trigger, procedure,
or
package. In a separate PL/SQL procedure or anonymous block, you can
display the buffered information by calling the GET_LINE procedure.

If you do not call GET_LINE, or if you do not display the messages on
your screen in SQL*Plus or Enterprise Manager, then the buffered
messages are ignored. The DBMS_OUTPUT package is especially useful for
displaying PL/SQL debugging information.

           Note:

           Messages sent using DBMS_OUTPUT are not actually sent until
the                sending subprogram or trigger completes. There
           is no mechanism to flush output during the execution of
a                      procedure.  

Security

At the end of this script, a public synonym (DBMS_OUTPUT) is created and
EXECUTE permission on this package is granted to public.

Errors

DBMS_OUTPUT subprograms raise the application error ORA-20000, and the
output procedures can return the following errors:

Table 26-1 DBMS_OUTPUT

Error                     Description
ORU-10027:                Buffer overflow  
ORU-10028:                Line length overflow
--
Ron Reidy
Oracle DBA
Reidy Consulting, L.L.C.



Wed, 24 Mar 2004 06:25:06 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. ORU-10027 buffer overflow with JDBC classes12.zip driver

2. ORU-10027 error caused by DBMS_OUTPUT calls in a function

3. dbms_output.put_line - Handling ORU-10027 exceptions

4. ORU-10027 buffer overflow with JDBC classes12.zip driver

5. ora-20000, oru-10027 buffer overflow, limit of 2000 bytes

6. 10027 - out-of-band

7. -10027: buffer overflow, limit of 1000000 bytes

8. ORacle 8 dbms_output ORU-10028 problem (urgent help reqd)

9. Question Re: ORU-10028 Error Message

10. ORU message?

11. ORU-10020 (no typo!) Error 2 on lock request


 
Powered by phpBB® Forum Software