Rene Nyffenegger <rene.nyffenegger_at_gmx.ch> wrote in
news:bnbulj$vlvbk$1_at_ID-82536.news.uni-berlin.de:
>
> Seems like you're looking for dbms_alert
>
> From the documentation:
> DBMS_ALERT supports asynchronous notification of database events
> (alerts). By appropriate use of this package and database triggers, an
> application can notify itself whenever values of interest in the
> database are changed.
>
> [...]
>
> Alerts are transaction-based. This means that the waiting session is
> not alerted until the transaction signalling the alert commits. There
> can be any number of concurrent signalers of a given alert, and there
> can be any number of concurrent waiters on a given alert.
>
>
> hth
> Rene
>
>
DBMS_ALERT seems to be just the ticket.
Thanks very much for that.
Received on Sat Oct 25 2003 - 22:16:18 CDT
