Register interest in an alert. : DBMS_ALERT « System Packages « Oracle PL / SQL






  1. Oracle PL / SQL
  2. System Packages
  3. DBMS_ALERT

Register interest in an alert.

    
SQL> BEGIN
  2
  3    
  4    DBMS_ALERT.REGISTER('EVENT_MESSAGE_QUEUE');
  5
  6  END;
  7  /

PL/SQL procedure successfully completed.

SQL>
SQL>








Related examples in the same category

1.Receiving an alert using DBMS_ALERT.
2.dbms_alert.signal
3.dbms_alert.waitone
4.Remove your registered interest in a DBMS_ALERT.
5.Sending an alert through DBMS_ALERT.