Install, Upgrade, Clone, Patch - EBS (MOSC)

MOSC Banner

Patch 13330482:R12.GL.B : objects invalidated with PLS-00801: internal error [1401]

edited Jan 4, 2013 10:41AM in Install, Upgrade, Clone, Patch - EBS (MOSC) 12 commentsAnswered
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.
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center