XML Database (MOSC)

MOSC Banner

Invlaid Oracle XML Database 11.2.0.3

edited Mar 18, 2013 5:03AM in XML Database (MOSC) 6 commentsAnswered
select owner, object_name, object_type, status from dba_objects where status = 'INVALID' and owner = 'XDB';


OWNER                    OBJECT_NAME                    OBJECT_TYPE
------------------------ ------------------------------ -------------------
STATUS
-------
XDB                      DBMS_RESCONFIG                 PACKAGE BODY
INVALID

 show errors
Errors for PACKAGE BODY XDB.DBMS_RESCONFIG:

LINE/COL ERROR
-------- -----------------------------------------------------------------
67/8     PL/SQL: SQL Statement ignored
69/26    PL/SQL: ORA-22881: dangling REF
179/8    PL/SQL: SQL Statement ignored
181/26   PL/SQL: ORA-22881: dangling REF

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