SQL>
SQL> create or replace package pkg_a is
2 v_a number:=0;
3 function a1 return NUMBER;
4 end;
5 /
Package created.
SQL> create or replace package body pkg_a is
2 function a1 return NUMBER is
3 begin
4 return 0;
5 end;
6 end;
7 /
Package body created.
SQL> create or replace package pkg_b is
2 function b1 return NUMBER;
3 end;
4 create or replace package body pkg_b is
5 function b1 return NUMBER is
6 begin
7 return pkg_a.a1+1;
8 end;
9 end;
10 /
Warning: Package created with compilation errors.
SQL>
SQL> select object_name||' '||object_type
2 from user_objects
3 where status = 'INVALID';
OBJECT_NAME||''||OBJECT_TYPE
---------------------------------------
ADDNEWEMPLOYEE PROCEDURE
ADDNEWROW PROCEDURE
ADD_NEW_EMPLOYEE PROCEDURE
ALMOSTFULL FUNCTION
AUTHORS_SEL PROCEDURE
AUTHOR_FIRST_NAME_UPD PROCEDURE
AUTHOR_SEL PROCEDURE
BIGUTIL PACKAGE
BIGUTIL PACKAGE BODY
BIND_TEST PROCEDURE
COMPILE_WARNING PROCEDURE
DELETEEMPLOYEE FUNCTION
DELETEMYEMPLOYEE PROCEDURE
EMPLOYEEDATA PACKAGE
EMPLOYEEINFO FUNCTION
EMPLOYEEOPS PACKAGE
EMPLOYEEOPS PACKAGE BODY
EMPLOYEEPACKAGE PACKAGE
EMPLOYEEPACKAGE PACKAGE BODY
EMPLOYEE_COUNT PROCEDURE
EMPLOYEE_PACKAGE PACKAGE BODY
EMPLOYEE_VIEW VIEW
EMPLOYEE_VIEW_TRIGGER TRIGGER
EMP_CHANGE_S PROCEDURE
EMP_DATA VIEW
EMP_NAME_CHANGE TRIGGER
FULLNAME FUNCTION
F_EMP_DSP FUNCTION
F_GETDIFF FUNCTION
F_GETDNAME FUNCTION
F_GETEMPS FUNCTION
F_MAKEADDRESS FUNCTION
F_VALIDATESALARY FUNCTION
HELLOFLE PROCEDURE
INSERT_NUMBERS PROCEDURE
LOG_SHUTDOWN TRIGGER
LOG_STARTUP TRIGGER
MEASURE_USAGE PROCEDURE
MYPROCEDURE PROCEDURE
NAMED_BLOCK PROCEDURE
NEWYORKEMP VIEW
PKG PACKAGE
PKG_ADIFFERENTUTIL PACKAGE BODY
PKG_B PACKAGE
PKG_B PACKAGE BODY
PKG_EMP PACKAGE
PKG_EMP PACKAGE BODY
PKG_UTIL PACKAGE
PRODUCTTYPE TYPE BODY
PRODUCT_PACKAGE PACKAGE
PRODUCT_PACKAGE PACKAGE BODY
P_PRINTEMPS PROCEDURE
P_UPDATELOC PROCEDURE
P_VALIDATESALARY PROCEDURE
RECORDFULLCLASSES PROCEDURE
TEST_TIME PROCEDURE
UPDATEEMPLOYEE FUNCTION
UPDATEMYEMPLOYEE PROCEDURE
UPDATE_EMP PROCEDURE
V_EMP VIEW
V_EMPLOYEE VIEW
V_EMP_IU TRIGGER
62 rows selected.
SQL>