Database Install/Upgrade/Opatch (MOSC)

MOSC Banner

one invalid sys object: sys.dbms_sqlpa

edited Mar 21, 2013 3:26AM in Database Install/Upgrade/Opatch (MOSC) 4 commentsAnswered
Not sure if this needs to be fixed prior to manual upgrade process, or will it get fixed during upgrade?

SQL> alter package SYS.DBMS_SQLPA compile body;

Warning: Package Body altered with compilation errors.

SQL> show errors;
Errors for PACKAGE BODY SYS.DBMS_SQLPA:

LINE/COL ERROR
-------- -----------------------------------------------------------------
113/5    PL/SQL: SQL Statement ignored
118/44   PL/SQL: ORA-00904: "OTHER_XML": invalid identifier

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