WAITANY procedure

The WAITANY procedure waits for any registered alerts to occur.

Syntax


1  DBMS_ALERT.WAITANY ( name , message , status , timeout )

Procedure parameters

name
An output argument of type VARCHAR(128) that contains the name of the alert.
message
An output argument of type VARCHAR(32672) that contains the message sent by the SIGNAL procedure.
status
An output argument of type INTEGER that contains the status code returned by the procedure. The following values are possible
0
An alert occurred.
1
A timeout occurred.
timeout
An input argument of type INTEGER that specifies the amount of time in seconds to wait for an alert.