Invalid objects under ORDSYS after downgrade to 9.2 (Doc ID 552849.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Multimedia - Version: 10.2.0.1 to 10.2.0.4 - Release: 10.2 to 10.2
Information in this document applies to any platform.

Symptoms

Downgrading from 10.2 to 9.2, the following objects are invalid after downgrade:

OWNER      OBJECT_NAME                    OBJECT_TYPE
---------- ------------------------------ ---------------
ORDSYS     IMGSCORE                       OPERATOR
ORDSYS     IMGSIMILAR                     OPERATOR
ORDSYS     ORDIMAGEINDEX                  INDEXTYPE
ORDSYS     ORDIMGIDXMETHODS               TYPE
ORDSYS     ORDIMGIDXMETHODS               TYPE BODY
ORDSYS     SCOREFUNC                      FUNCTION
ORDSYS     SIMILARFUNC                    FUNCTION

The logfile generated during downgrade may show the following errors:

 CREATE OR REPLACE TYPE BODY ORDIMGIDXMethods
    *
    ERROR at line 1:
    ORA-04045: errors during recompilation/revalidation of ORDSYS.ORDIMGIDXMETHODS
    ORA-06545: PL/SQL: compilation error - compilation aborted
    ORA-06550: line 0, column 0:
    PLS-00908: The stored format of ORDIMGIDXMETHODS is not supported by this release
    ORA-06550: line 0, column 0:
    PLS-00707: unsupported construct or internal error [2603]
    ORA-06550: line 0, column 0:
    PLS-00565: ORDIMGIDXMETHODS must be completed as a potential REF target (object type)

Changes

Downgraded from 10.2. to 9.2

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