Call dbms_alert.signal in a loop : DBMS_ALERT « System Packages « Oracle PL/SQL Tutorial





SQL>
SQL> begin
  2    for i in 1 .. 10 loop
  3       dbms_alert.signal( 'MyAlert', 'Message ' || i );
  4    end loop;
  5  end;
  6  /

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