ORDSYS.ORD_DICOM_ADMIN_PRV Invalid After Re-Running Catalog Script (Doc ID 951178.1)

Last updated on MAY 13, 2013

Applies to:

Oracle Multimedia - Version 11.1.0.6.0 to 11.1.0.7.0
Information in this document applies to any platform.
***Checked for relevance on 18-Jul-2012***

Symptoms

-- Problem Statement:
After re-running catalog.sql script package ORD_DICOM_ADMIN_PRV changed to invalid state.

-- Steps To Reproduce:

shutdown immediate
startup upgrade
spool /tmp/catalog.log
start ?/rdbms/admin/catalog.sql
spool /tmp/catproc.log
start ?/rdbms/admin/catproc.sql
shutdown immediate
-- normal startup
startup
start ?/rdbms/admin/utlrp.sql

select comp_name, version, status from dba_registry where comp_id = 'ORDIM';

COMP_NAME                          VERSION                        STATUS
---------------------------------- ------------------------------ -----------
Oracle Multimedia                  11.1.0.7.0                     INVALID

-- There is one invalid Multimedia object - ORD_DICOM_ADMIN_PRV.

SQL> select object_type,object_name, owner from dba_objects 
  where status ='INVALID'
  order by owner, object_name, object_type;

OBJECT_TYPE         OBJECT_NAME                    OWNER
------------------- ------------------------------ --------
PACKAGE BODY        ORD_DICOM_ADMIN_PRV            ORDSYS

SQL> alter package ORDSYS.ORD_DICOM_ADMIN_PRV compile body;

Warning: Package Body altered with compilation errors.

SQL> show errors

Errors for PACKAGE BODY ORDSYS.ORD_DICOM_ADMIN_PRV:

LINE/COL ERROR
-------- -----------------------------------------------------------------
3824/7   PL/SQL: SQL Statement ignored
3826/11  PL/SQL: ORA-00932: inconsistent datatypes: expected - got -
3839/9   PL/SQL: SQL Statement ignored
3841/13  PL/SQL: ORA-00932: inconsistent datatypes: expected - got -
3854/9   PL/SQL: SQL Statement ignored
3856/13  PL/SQL: ORA-00932: inconsistent datatypes: expected - got -

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms