Oracle in a Nutshell

Calls

PROCEDURE DBMS_ALERT.REGISTER (name IN VARCHAR2);

Registers the calling session to receive notification of alert name.

PROCEDURE DBMS_ALERT.REMOVE (name IN VARCHAR2);

Unregisters the calling session from receiving notification of alert name.

PROCEDURE DBMS_ALERT.REMOVEALL;

Unregisters the calling session from notification of all alerts. New with Oracle8i.

PROCEDURE DBMS_ALERT.SET_DEFAULTS (sensitivity IN NUMBER);

Defines configurable settings for the calling session in seconds.

PROCEDURE DBMS_ALERT.SIGNAL (name IN VARCHAR2, message IN VARCHAR2);

Signals the occurrence of alert name and attaches message. Sessions registered for alert name are notified only when the signaling transaction commits.

PROCEDURE DBMS_ALERT.WAITANY (name OUT VARCHAR2, message OUT VARCHAR2, status OUT INTEGER, timeout IN NUMBER DEFAULT MAXWAIT);

Waits for up to timeout seconds to be notified of any alerts for which the session is registered. If status = 0, then name and message contain alert information. If status = 1, then timeout seconds have elapsed without notification of any alert.

PROCEDURE DBMS_ALERT.WAITONE (name IN VARCHAR2, message OUT VARCHAR2, status OUT INTEGER, timeout IN NUMBER DEFAULT MAXWAIT);

Waits for up to timeout seconds for notification of alert name.