Re: DBMS_PIPE

As far as I know the dbms_pipe package doesn't offer any facility to find out the number of messages within a pipe. At least you can maintain a counter by yourself into a table incrementing it when a new message is put into the pipe and decrement it when the message is extracted from within the same pipe.

Regards,
talek

z1hou1_at_gmail.com wrote:
> How do I check the number of messages that are in a pipe? I would like
> to stop sending messages to the pipe if the number of messages exceeds
> a certain number.
>
> Thank you in advance for any response.
>
> Regards,
> z1hou1
Received on Fri May 11 2007 - 17:16:59 CDT