SIGNAL procedure

The SIGNAL procedure signals the occurrence of a specified alert. The signal includes a message that is passed with the alert. The message is distributed to the listeners (processes that have registered for the alert) when the SIGNAL call is issued.

Syntax


>>-DBMS_ALERT.SIGNAL--(--name--,--message--)-------------------><

Procedure parameters

name: An input argument of type VARCHAR(128) that specifies the name of the alert.
message: An input argument of type VARCHAR(32672) that specifies the information to pass with this alert. This message can be returned by the WAITANY or WAITONE procedures when an alert occurs.