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

MOSC Banner

After applying the patch(14642977) in source(TSTR12) instance got the following invalid:

edited Jun 26, 2018 10:35AM in Install, Upgrade, Clone, Patch - EBS (MOSC) 3 commentsAnswered

HI All,
After applying the patch(14642977) in source(TSTR12) instance got the following invalid and following are the compilation errors
=============================================================================================================

SQL> alter package AHL_AVF_PRIM_VSTS_PVT
  2  compile body;

Warning: Package Body altered with compilation errors.

SQL> show errors
Errors for PACKAGE BODY AHL_AVF_PRIM_VSTS_PVT:

LINE/COL ERROR
-------- -----------------------------------------------------------------
1325/19  PL/SQL: Statement ignored
1325/19  PLS-00201: identifier 'CONTINUE' must be declared
1598/19  PL/SQL: Statement ignored
1598/19  PLS-00201: identifier 'CONTINUE' must be declared

************************************************************************************************************************************************
SQL> alter package AHL_COMPLEX_MX_RWSC_PVT compile body;

Warning: Package Body altered with compilation errors.

SQL> show errors
Errors for PACKAGE BODY AHL_COMPLEX_MX_RWSC_PVT:

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