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: 65082
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: 65082
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 Jul 21 03:47:00 CDT 2017

Total time taken to generate the page: 0.23346 seconds