dbms_alert.waitone : DBMS_ALERT « System Packages « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. System Packages
3. DBMS_ALERT

SQL>
SQL> set serveroutput on
SQL> declare
  2      l_status    number;
  3      l_msg       varchar2(1800);
  4  begin
  5      dbms_alert.waitone( name    => 'MyAlert',
  6                          message => l_msg,
  7                          status  => l_status,
  8                          timeout => dbms_alert.maxwait );
  9
 10      if ( l_status = 0 )
 11      then
 12          dbms_output.put_line( 'Msg from event is ' || l_msg );
 13      end if;
 14  end;
 15  /