Re: DBMS_PIPE vs DBMS_ALERT

In article <374A5776.F4C4AB5F_at_home.com>, Furkan Khan <khanf_at_home.com> writes
>Folks, has any one used these APIs ? If so can some
>shed some light on the pros and cons of the two
>mechanisms.
>
>I have used DBMS_PIPE, it seems to work,
>but its not very reliable.

In what way didn't you find it to it to be reliable? We tried DBMS_ALERT and then fell back to DBMS_PIPE as we seemed to get some 'locking' problems with the ALERT e.g. if too many alerts were raised without being responded to, the later alerts had to wait.

--
Andy Hardy. PGP key available on request