DBMS_ALERT.REGISTER : DBMS_ALERT « System Packages « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. System Packages
  3. DBMS_ALERT
SQL>
SQL> CREATE OR REPLACE PROCEDURE p_register
  2  IS
  3  BEGIN
  4      DBMS_ALERT.REGISTER('ALERTTEST');
  5  END;
  6  /

SQL>
SQL> drop procedure p_register ;

Procedure dropped.

SQL>
SQL>
SQL>








31.1.DBMS_ALERT
31.1.1.DBMS_ALERT.REGISTER
31.1.2.dbms_alert.waitone
31.1.3.Call dbms_alert.signal in a loop
31.1.4.Signal along with the entries in a table
31.1.5.Singal with dbms_alert.signal
31.1.6.Registers the alert for the session
31.1.7.Call DBMS_ALERT.SIGNAL in a trigger