Re: DBMS_PIPE

On May 11, 3:00 pm, z1h..._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

I don't know much about it, but looking at the docs it seems there is a maxpipesize parameter when you create the pipe, and you will be blocked when the pipe is full. So stop sending when you are blocked.

jg

--
@home.com is bogus.
"stupid_query_detection=off | normal | aggressive | facist" - Andre