Singal with dbms_alert.signal : DBMS_ALERT « System Packages « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. System Packages
  3. DBMS_ALERT
SQL>
SQL> set echo on
SQL>
SQL> exec dbms_alert.signal( 'MyAlert', 'Hello World' );

PL/SQL procedure successfully completed.

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