Mega Code Archive

 

Categories / Oracle PLSQL / System Packages

 

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; / --