Title :
ORA-06558 buffer in dbms_pipe package is full. No more items allowed
Cause :
The pipe buffer size has been exceeded.
Action :
Inspect the program to analyze the rate of input and output to the pipe. You might need to take items out of the pipe by executing RECEIVE_ MESSAGE, or empty the entire pipe by executing PURGE on the pipe.