Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / System Packages

 

Registers the alert for the session

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; /