Mega Code Archive

 

Categories / Oracle PLSQL / System Packages

 

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.