Patch 14089136: Results in Invalid object PA_PROJ_ACCUM_MAIN
Hi,
Issue:
---------
Post application of Patch resulted in Invalid PA_PROJ_ACCUM_MAIN
SQL> alter package PA_PROJ_ACCUM_MAIN compile body;
Warning: Package Body altered with compilation errors.
SQL> show errors
Errors for PACKAGE BODY PA_PROJ_ACCUM_MAIN:
LINE/COL ERROR
-------- -----------------------------------------------------------------
2124/12 PLS-00341: declaration of cursor 'SELPRJS' is incomplete or
malformed
2125/5 PL/SQL: SQL Statement ignored
2137/61 PL/SQL: ORA-00942: table or view does not exist
LINE/COL ERROR
-------- -----------------------------------------------------------------
2234/26 PLS-00364: loop index variable 'PROJREC' use is invalid
2236/13 PL/SQL: Statement ignored
Compiled PA schema. Please find below versions of the package.
$Header PARESMNB.pls 115.58 2012/05/15 09:33:33 krkondur ship $
Tagged:
0