WAITONE procedure

The WAITONE procedure waits for a specified alert to occur.

Syntax


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

Procedure parameters

name
An input argument of type VARCHAR(128) that specifies 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 the specified alert.