SQL> @rough.sql SQL> alter PACKAGE DBMS_ASYNCRPC_PUSH compile body; Warning: Package Body altered with compilation errors. SQL> show error Errors for PACKAGE BODY DBMS_ASYNCRPC_PUSH: LINE/COL ERROR -------- ----------------------------------------------------------------- 103/27 PL/SQL: Statement ignored 103/49 PLS-00302: component 'RESULT_STARTUP_SECONDS' must be declared SQL> SQL> alter PACKAGE DBMS_DEFER_INTERNAL_SYS compile body; Warning: Package Body altered with compilation errors. SQL> show error Errors for PACKAGE BODY DBMS_DEFER_INTERNAL_SYS: LINE/COL ERROR -------- ----------------------------------------------------------------- 132/11 PL/SQL: Statement ignored 132/30 PLS-00302: component 'DELETE_TRAN' must be declared 1385/11 PL/SQL: Statement ignored 1386/28 PLS-00302: component 'ALREADYPROPAGATOR_NUM' must be declared 1388/11 PL/SQL: Statement ignored 1389/28 PLS-00302: component 'DUPLICATEPROPAGATOR_NUM' must be declared SQL> SQL> alter PACKAGE DBMS_DEFER_SYS_PART1 compile body; Warning: Package Body altered with compilation errors. SQL> show error Errors for PACKAGE BODY DBMS_DEFER_SYS_PART1: LINE/COL ERROR -------- ----------------------------------------------------------------- 389/7 PL/SQL: Statement ignored 389/56 PLS-00302: component 'MISSINGUSER_NUM' must be declared 411/5 PL/SQL: Statement ignored 411/20 PLS-00302: component 'DELETE_ERROR' must be declared SQL> SQL> alter PACKAGE DBMS_IAS_MT_INST compile body; Warning: Package Body altered with compilation errors. SQL> show error Errors for PACKAGE BODY DBMS_IAS_MT_INST: LINE/COL ERROR -------- ----------------------------------------------------------------- 150/7 PL/SQL: Statement ignored 150/22 PLS-00302: component 'UNREGISTER_PROPAGATOR' must be declared SQL> SQL> alter PACKAGE DBMS_REPCAT_MIG_INTERNAL compile body; Warning: Package Body altered with compilation errors. SQL> show error Errors for PACKAGE BODY DBMS_REPCAT_MIG_INTERNAL: LINE/COL ERROR -------- ----------------------------------------------------------------- 1143/7 PL/SQL: Statement ignored 1143/56 PLS-00302: component 'DUPLICATEPROPAGATOR_NUM' must be declared SQL> SQL> SQL> alter session set current_schema=MAILBOX; Session altered. SQL> alter PACKAGE MM2IDS compile body; Warning: Package Body altered with compilation errors. SQL> show error No errors. SQL>