PA_PWP_SUMM_PKG is invalid after upgrade database from 9.2.0.8 to 11.2.0.2 and application from 11.5
PA_PWP_SUMM_PKG is invalid after upgrade database from 9.2.0.8 to 11.2.0.2 and application from 11.5.8 to 12.1.3:SQL> select text from user_source where name='PA_PWP_SUMM_PKG' and line=2;
TEXT
--------------------------------------------------------------------------------
-- $Header: PAPWPSMS.pls 120.0.12010000.2 2009/01/17 06:07:06 jjgeorge noship $
-- $Header: PAPWPSMB.pls 120.0.12010000.17 2009/08/07 11:56:03 sosharma noship
$
SQL> alter package PA_PWP_SUMM_PKG compile;
Warning: Package altered with compilation errors.
SQL> show error;
No errors.
SQL>
SQL> select line,text from user_errors where name='PA_PWP_SUMM_PKG';
LINE
----------
TEXT
--------------------------------------------------------------------------------
375
PL/SQL: ORA-00942: table or view does not exist
342
PL/SQL: SQL Statement ignored
TEXT
--------------------------------------------------------------------------------
-- $Header: PAPWPSMS.pls 120.0.12010000.2 2009/01/17 06:07:06 jjgeorge noship $
-- $Header: PAPWPSMB.pls 120.0.12010000.17 2009/08/07 11:56:03 sosharma noship
$
SQL> alter package PA_PWP_SUMM_PKG compile;
Warning: Package altered with compilation errors.
SQL> show error;
No errors.
SQL>
SQL> select line,text from user_errors where name='PA_PWP_SUMM_PKG';
LINE
----------
TEXT
--------------------------------------------------------------------------------
375
PL/SQL: ORA-00942: table or view does not exist
342
PL/SQL: SQL Statement ignored
Tagged:
0