Registers the alert for the session : DBMS_ALERT « System Packages « Oracle PL/SQL Tutorial






SET SERVEROUTPUT ON SIZE 1000000
DECLARE
   lv_message_txt VARCHAR2(1800);
   lv_status_num  PLS_INTEGER;
BEGIN
   
   DBMS_ALERT.REGISTER('REORDER_THRESHOLD_ALERT');
   FOR lv_count_num IN 1..10 LOOP
      DBMS_ALERT.WAITONE('REORDER_THRESHOLD_ALERT',lv_message_txt, lv_status_num);
      IF lv_status_num = 0 THEN
         DBMS_OUTPUT.PUT_LINE(lv_message_txt);
      ELSE
         DBMS_OUTPUT.PUT_LINE('Alert Failed.');
      END IF;
   END LOOP;
END;
/








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