Inline procedure : Code Block « PL SQL Programming « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. PL SQL Programming
  3. Code Block
SQL>
SQL>
SQL> DECLARE
  2     PROCEDURE myProc (dt IN VARCHAR2) IS
  3     BEGIN
  4        DBMS_OUTPUT.PUT_LINE (dt || ' -> ' || ADD_MONTHS (dt, 1));
  5     END;
  6  BEGIN
  7     myProc ('30-JAN-99');
  8     myProc ('27-FEB-99');
  9  END;
 10  /
30-JAN-99 -> 28-FEB-99
27-FEB-99 -> 27-MAR-99

PL/SQL procedure successfully completed.

SQL>
SQL>








24.4.Code Block
24.4.1.This is an anonymous procedure, so it has no name
24.4.2.A PL/SQL Block
24.4.3.Uses a PL/SQL Nested Block
24.4.4.Inline procedure
24.4.5.the forward slash on a line by itself says execute this procedure
24.4.6.Inner function
24.4.7.Select the first names for the Doe family from the Worker table.
24.4.8.Inner procedure in an anonymous function
24.4.9.Demonstrate nested PL/SQL blocks