Calls
-
PROCEDURE DBMS_ALERT.REGISTER(nameIN VARCHAR2); Registers the calling session to receive notification of alert name.
-
PROCEDURE DBMS_ALERT.REMOVE(nameIN 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(sensitivityIN NUMBER); Defines configurable settings for the calling session in seconds.
-
PROCEDURE DBMS_ALERT.SIGNAL(nameIN VARCHAR2,messageIN 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(nameOUT VARCHAR2,messageOUT VARCHAR2,statusOUT INTEGER,timeoutIN 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(nameIN VARCHAR2,messageOUT VARCHAR2,statusOUT INTEGER,timeoutIN NUMBER DEFAULT MAXWAIT); Waits for up to timeout seconds for notification of alert name.