Sending an alert through DBMS_ALERT. : DBMS_ALERT « System Packages « Oracle PL / SQL






Sending an alert through DBMS_ALERT.

   

set serveroutput on

DECLARE
  v_AlertName VARCHAR2(30) := 'MyAlert';
BEGIN
  DBMS_ALERT.SIGNAL(v_AlertName, 'Alert!  Alert!  Alert!');
  
  COMMIT;
END;
/


--

   
    
  








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.Register interest in an alert.