solidDB Help : solidDB reference : SQL: Statements : WAIT EVENT
  
WAIT EVENT
WAIT EVENT [event‑specification …] END WAIT
where:
event‑specification::= WHEN event‑name [(parameters)] BEGIN statements END EVENT
Note You can use the WAIT EVENT statement only inside stored procedures. For more details, see CREATE PROCEDURE.
Access requirements
Database user
Usage
In a stored procedure, use the WAIT EVENT statement to make the procedure wait for an event to happen.
You can use WAIT EVENT with both system-defined events and user-defined events.
Example
WAIT EVENT
-- When the event named "event1" is received...
WHEN event1
BEGIN eventresult := 'event1';
-- Insert a record into the event_records table showing that
-- this event was posted and received.
   EXEC SQL PREPARE call_cursor
   CALL insert_a_record(?);
   EXEC SQL EXECUTE call_cursor USING (eventresult);
   EXEC SQL CLOSE call_cursor;
   EXEC SQL DROP call_cursor;
   RETURN;
END EVENT
Go up to
SQL: Statements