dbms_alert.signal
SQL> SQL> begin 2 dbms_alert.signal( 'WAITING', '' ); 3 commit; 4 end; 5 / PL/SQL procedure successfully completed. SQL> SQL>