Database DataWarehousing (MOSC)

MOSC Banner

ODMR invalid objects - package bodies do not compile

edited Jun 23, 2011 8:34AM in Database DataWarehousing (MOSC) 3 commentsAnswered
 After installing ODM in a new 11.2 database by running the script  installodmr.sql,    the script validateODMRSYS.sql lists 6 invalid objects
Invalid ODMRSYS Objects Report
 
Type: PACKAGE BODY Name: ODMR_ENGINE_SEC Status: INVALID
Type: PACKAGE BODY Name: ODMR_INTERNAL_UTIL_SEC Status: INVALID
Type: PACKAGE BODY Name: ODMR_PROJECT Status: INVALID
Type: PACKAGE BODY Name: ODMR_PROJECT_SEC Status: INVALID
Type: PACKAGE BODY Name: ODMR_WORKFLOW Status: INVALID
Type: PACKAGE BODY Name: ODMR_WORKFLOW_SEC Status: INVALID
 
Total Number of Invalid Objects: 6

I tried compiling each of these package bodies from SQL Developer 3.0.  They each return errors as listed below.

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