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 /