Inner procedure : Procedure Definition « Stored Procedure Function « Oracle PL / SQL

1. Oracle PL / SQL
2. Stored Procedure Function
3. Procedure Definition

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>

   
    
    
  

Related examples in the same category