C.2 DBMS_ALERT

Appendix C
Built-In Packages

 

---

The DBMS_ALERT package provides support for notification of database events. You can use DBMS_ALERT to automatically detect that an event occurred, and then notify any process which is waiting for a signal from that alert. Many DBMS_ALERT programs perform at length, are not case-sensitive, and should not start with ORA$.

C.2.1 The REGISTER procedure

The REGISTER procedure adds your session and the specified alert to the master registration list. A session can register its interest in any number of alerts. The specification is:

PROCEDURE DBMS_ALERT.REGISTER (name IN VARCHAR2);