Mega Code Archive
Categories
/
Oracle PLSQL Tutorial
/
System Packages
Call dbms_alert signal in a loop
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>