Home » SQL & PL/SQL » SQL & PL/SQL » DBMS_PIPE Error (10.2.0.3.0)
DBMS_PIPE Error [message #410076] Thu, 25 June 2009 01:50 Go to next message
user71408
Messages: 585
Registered: November 2007
Location: NE
Senior Member

Hi All,

I am facing issues in executing one procedure.

I am getting below error.
DECLARE
*
ORA-06558: buffer in dbms_pipe package is full.  No more items allowed

ORA-06558: buffer in dbms_pipe package is full.  No more items allowed

ORA-06558: buffer in dbms_pipe package is full.  No more items allowed

ORA-06558: buffer in dbms_pipe package is full.  No more items allowed

ORA-06558: buffer in dbms_pipe package is full.  No more items allowed

ORA-06558: buffer in dbms_pipe package is full.  No more items allowed

ORA-06558: buffer in dbms_pipe package is full.  No more items allowed

ORA-06558: buf

*** Script stopped due to error ***


Can anybody please let me know the solution for this..


Thank you,
SNN
Re: DBMS_PIPE Error [message #410083 is a reply to message #410076] Thu, 25 June 2009 02:21 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-06558: buffer in dbms_pipe package is full.  No more items allowed
 *Cause:    The pipe buffer size has been exceeded.
 *Action:

Pop the items from the pipe.

Regards
Michel
Re: DBMS_PIPE Error [message #410084 is a reply to message #410076] Thu, 25 June 2009 02:29 Go to previous message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
... or/and increase pipe size at creation time.

Regards
Michel
Previous Topic: PRIVILEGES LIST/REFERENCE
Next Topic: what wrong here?
Goto Forum:
  


Current Time: Fri Dec 09 19:03:28 CST 2016

Total time taken to generate the page: 0.13329 seconds