Forward Referencing : Procedure Definition « Stored Procedure Function « Oracle PL / SQL






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

Forward Referencing

    
SQL>
SQL> DECLARE
  2    PROCEDURE b (caller VARCHAR2);  -- This is a forward referencing stub.
  3    PROCEDURE a (caller VARCHAR2) IS
  4      procedure_name VARCHAR2(1) := 'A';
  5    BEGIN
  6      dbms_output.put_line('Procedure "A" called by ['||caller||']');
  7      b(procedure_name);
  8    END;
  9    PROCEDURE b (caller VARCHAR2) IS
 10      procedure_name VARCHAR2(1) := 'B';
 11    BEGIN
 12      dbms_output.put_line('Procedure "B" called by ['||caller||']');
 13    END;
 14  BEGIN
 15    a('Main');
 16  END;
 17  /
Procedure "A" called by [Main]
Procedure "B" called by [A]

PL/SQL procedure successfully completed.

SQL>








Related examples in the same category

1.Creat an empty procedure
2.replace a procedure
3.Create a stored procedure and how to call it.
4.Define procedure to insert data
5.Define and call procedure
6.Create procedure with authid
7.Create a stored procedure with authid
8.Mutually exclusive local subprograms.
9.A forward declaration.
10.Inner procedure
11.Save calculation result to a table in procedure
12.exception throwed out of the procedure
13.AUTHID clause in a CREATE PROCEDURE statement indicates that this procedure is being created with user's or invoker's rights
14.Increase gift price
15.A local subprogram within a stored procedure
16.Overloaded local procedures: number and varchar2
17.Using all the default values
18.Mark procedure with authid current_user
19.Reference package variable in a procedure
20.Only manager can change the password