Crosss reference between two packages : Packages « Function Procedure Packages « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. Function Procedure Packages
3. Packages

SQL>
SQL> create or replace package myPackage
  2  as
  3    PROCEDURE P1;
  4    PROCEDURE P2;
  5    PROCEDURE P3;
  6    FUNCTION F1 return number;
  7    FUNCTION F2 return number;
  8  end;
  9  /

Package created.

SQL>
SQL> create or replace package myPackage2
  2  as
  3    PROCEDURE P3;
  4    PROCEDURE P4;
  5    PROCEDURE P5;
  6    FUNCTION F1 return number;
  7    FUNCTION F3 return number;
  8  end;
  9  /

Package created.

SQL>
SQL> create or replace package body myPackage2
  2  as
  3    PROCEDURE P3
  4    as
  5      begin
  6        myPackage.P3;
  7      end;
  8
  9    FUNCTION F1 return number
 10    as
 11      begin
 12        return myPackage.F1;
 13      end;
 14
 15    PROCEDURE P4
 16    as
 17      begin
 18        null;
 19      end;
 20
 21    PROCEDURE P5
 22    as
 23      begin
 24        null;
 25      end;
 26
 27    FUNCTION F3 return number
 28    as
 29      begin
 30        return 1;
 31      end;
 32  end;
 33  /

Package body created.

SQL>
SQL> create or replace package body myPackage
  2  as
  3    PROCEDURE P1
  4    as
  5      begin
  6        null;
  7      end;
  8
  9    PROCEDURE P2
 10    as
 11      begin
 12        null;
 13      end;
 14
 15    PROCEDURE P3
 16    as
 17      begin
 18        null;
 19      end;
 20
 21    FUNCTION F1 return number
 22    as
 23      begin
 24        return 1;
 25      end;
 26
 27    FUNCTION F2 return number
 28    as
 29      begin
 30        return 1;
 31      end;
 32  end;
 33  /

Package body created.

SQL>
SQL>