ODMR invalid objects - package bodies do not compile
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.
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.
0