Mega Code Archive
Reference method from another package
<![CDATA[
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>
]]>