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$.
PROCEDURE DBMS_ALERT.REGISTER (name IN VARCHAR2);
The REMOVE procedure removes the specified alert for the current session from the registration list. After a call to REMOVE, your application will no longer respond to the named alert when issued by SIGNAL. The specification is:
PROCEDURE DBMS_ALERT.REMOVE (name IN VARCHAR2);
The REMOVEALL procedure removes all alerts for the current session from the registration list. After a call to REMOVEALL, your application will no longer respond to any alerts issued by SIGNAL. The specification is:
C.2.4 The SET_DEFAULTS procedure
Use the SET_DEFAULTS procedure to set the amount of time (in seconds) for the POLLING_INTERVAL, which applies when DBMS_ALERT goes into a polling loop. The specification is:
PROCEDURE DBMS_ALERT.SET_DEFAULTS (sensitivity IN NUMBER);
PROCEDURE DBMS_ALERT.SIGNAL (name IN VARCHAR2, message IN VARCHAR2);
PROCEDURE DBMS_ALERT.WAITANY (name OUT VARCHAR2, message OUT VARCHAR2, status OUT INTEGER, timeout IN NUMBER DEFAULT MAXWAIT);
Copyright (c) 2000 O'Reilly & Associates. All rights reserved.