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

MOSC Banner

Cannot compile invalid objects.

edited Jan 21, 2013 3:37AM in Install, Upgrade, Clone, Patch - EBS (MOSC) 16 commentsAnswered
 Hi Team,

Cannot compile invalid objects after application of Patch 1398445.

SQL>  Alter package PO_WF_UTIL_PKG compile;

Warning: Package altered with compilation errors.

SQL> show err
No errors.
SQL>  Alter package PO_WF_UTIL_PKG compile body;

Warning: Package Body altered with compilation errors.

SQL> show error
Errors for PACKAGE BODY PO_WF_UTIL_PKG:

LINE/COL ERROR
-------- -----------------------------------------------------------------
27/11    PLS-00323: subprogram or cursor 'SETITEMATTRTEXT' is declared in
        a package specification and must be defined in the package body

36/11    PLS-00323: subprogram or cursor 'SETITEMATTRNUMBER' is declared
        in a package specification and must be defined in the package
        body

56/10    PLS-00323: subprogram or cursor 'GETITEMATTRTEXT' is declared in
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