Oracle9i Supplied PL/SQL Packages and Types Reference Release 1 (9.0.1) Part Number A89852-02 |
|
DBMS_ALERT, 6 of 8
This procedure signals an alert. The effect of the SIGNAL
call only occurs when the transaction in which it is made commits. If the transaction rolls back, SIGNAL
has no effect.
All sessions that have registered interest in this alert are notified. If the interested sessions are currently waiting, they are awakened. If the interested sessions are not currently waiting, they are notified the next time they do a wait call.
Multiple sessions can concurrently perform signals on the same alert. Each session, as it signals the alert, blocks all other concurrent sessions until it commits. This has the effect of serializing the transactions.
DBMS_ALERT.SIGNAL ( name IN VARCHAR2, message IN VARCHAR2);
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|