System Packages Oracle PLSQL

  1. Home
  2. Oracle PLSQL
  3. System Packages
  4. 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;
/
--