Mega Code Archive

 

Categories / Oracle PLSQL / Stored Procedure Function

 

Inner procedure

SQL> SQL> SQL> DECLARE   2     lv_count_num PLS_INTEGER := 0;   3     PROCEDURE DISPLAY_VALUE (p_value_num PLS_INTEGER) IS   4     BEGIN   5        DBMS_OUTPUT.PUT_LINE('Variable Value: ' || p_value_num);   6     END;   7  BEGIN   8     display_value(lv_count_num);   9     lv_count_num := lv_count_num + 2;  10     display_value(lv_count_num);  11     lv_count_num := lv_count_num + 4;  12     display_value(lv_count_num);  13     lv_count_num := lv_count_num + 8;  14     display_value(lv_count_num);  15  END;  16  / Variable Value: 0 Variable Value: 2 Variable Value: 6 Variable Value: 14 PL/SQL procedure successfully completed. SQL>