Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / System Tables Data Dictionary

 

Check the package status in user_objects

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>