Oracle9i Supplied PL/SQL Packages and Types Reference Release 1 (9.0.1) Part Number A89852-02 |
|
DBMS_ALERT, 7 of 8
Call WAITANY
to wait for an alert to occur for any of the alerts for which the current session is registered. An implicit COMMIT
is issued before this procedure is executed. The same session that waits for the alert may also first signal the alert. In this case remember to commit after the signal and before the wait; otherwise, DBMS_LOCK
.REQUEST
(which is called by DBMS_ALERT
) returns status 4.
DBMS_ALERT.WAITANY ( name OUT VARCHAR2, message OUT VARCHAR2, status OUT INTEGER, timeout IN NUMBER DEFAULT MAXWAIT);
Table 2-7 WAITANY Procedure Parameters
-20000, ORU-10024: there are no alerts registered.
You must register an alert before waiting.
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|