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






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

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.