Remove your registered interest in a DBMS_ALERT. : DBMS_ALERT « System Packages « Oracle PL / SQL






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

Remove your registered interest in a DBMS_ALERT.

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

PL/SQL procedure successfully completed.








Related examples in the same category

1.Receiving an alert using DBMS_ALERT.
2.dbms_alert.signal
3.dbms_alert.waitone
4.Sending an alert through DBMS_ALERT.
5.Register interest in an alert.