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> SQL> SQL>