Reference method from another package : Package Body « Function Procedure Packages « Oracle PL/SQL Tutorial

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

SQL>
SQL> CREATE OR REPLACE PACKAGE myPackage1
  2  IS
  3     PROCEDURE proc;
  4  END;
  5  /

Package created.

SQL> CREATE OR REPLACE PACKAGE BODY myPackage1
  2  IS
  3     PROCEDURE proc
  4     IS
  5     BEGIN
  6        NULL;
  7     END;
  8  END;
  9  /

Package body created.

SQL> CREATE OR REPLACE PACKAGE not_myPackage2
  2  IS
  3     PROCEDURE proc;
  4  END;
  5  /

Package created.

SQL> CREATE OR REPLACE PACKAGE BODY not_myPackage2
  2  IS
  3     PROCEDURE proc
  4     IS
  5     BEGIN
  6        NULL;
  7     END;
  8  END;
  9  /

Package body created.

SQL>
SQL> CREATE OR REPLACE PACKAGE myPackage
  2  IS
  3     PROCEDURE proc1;
  4     PROCEDURE proc2;
  5  END;
  6  /

Package created.

SQL>
SQL> CREATE OR REPLACE PACKAGE BODY myPackage
  2  IS
  3     PROCEDURE proc1
  4     IS
  5     BEGIN
  6        myPackage1.proc;
  7     END;
  8
  9     PROCEDURE proc2
 10     IS
 11     BEGIN
 12        not_myPackage2.proc;
 13     END;
 14  END;
 15  /

Package body created.

SQL>
SQL>