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


1  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.