Patch 13330482:R12.GL.B : objects invalidated with PLS-00801: internal error [1401]
Hi All,
Above patch was suggested and there were many invalid objects.
All of them when recompiled showed
Errors for PACKAGE BODY GMDQSVRS_APPROVAL_WF_PKG:
LINE/COL ERROR
-------- -----------------------------------------------------------------
0/0 PLS-00801: internal error [1401]
0/0 PLS-00801: internal error [1401]
918/13 PL/SQL: Statement ignored
984/13 PL/SQL: Statement ignored
SQL>
SQL>
SQL>
SQL> alter package GMDQSPEC_APPROVAL_WF_PKG
2 compile body;
Warning: Package Body altered with compilation errors.
SQL> show error
Errors for PACKAGE BODY GMDQSPEC_APPROVAL_WF_PKG:
LINE/COL ERROR
-------- -----------------------------------------------------------------
0/0 PLS-00801: internal error [1401]
0/0 PLS-00801: internal error [1401]
626/13 PL/SQL: Statement ignored
692/13 PL/SQL: Statement ignored
SQL>
+ Recompiling via adadmin also is not reducing the list of invalid.
Above patch was suggested and there were many invalid objects.
All of them when recompiled showed
Errors for PACKAGE BODY GMDQSVRS_APPROVAL_WF_PKG:
LINE/COL ERROR
-------- -----------------------------------------------------------------
0/0 PLS-00801: internal error [1401]
0/0 PLS-00801: internal error [1401]
918/13 PL/SQL: Statement ignored
984/13 PL/SQL: Statement ignored
SQL>
SQL>
SQL>
SQL> alter package GMDQSPEC_APPROVAL_WF_PKG
2 compile body;
Warning: Package Body altered with compilation errors.
SQL> show error
Errors for PACKAGE BODY GMDQSPEC_APPROVAL_WF_PKG:
LINE/COL ERROR
-------- -----------------------------------------------------------------
0/0 PLS-00801: internal error [1401]
0/0 PLS-00801: internal error [1401]
626/13 PL/SQL: Statement ignored
692/13 PL/SQL: Statement ignored
SQL>
+ Recompiling via adadmin also is not reducing the list of invalid.
Tagged:
0