11.1.0.7.0 Patchset Install Fails on SDO_INDEX_METHOD_10I with PLS-538 on ODCIINDEXREWRITE (Doc ID 789185.1)

Last updated on OCTOBER 11, 2011

Applies to:

Oracle Spatial - Version: 11.1.0.6 to 11.1.0.7 - Release: 11.1 to 11.1
Oracle Spatial - Version: 11.1.0.6 to 11.1.0.7   [Release: 11.1 to 11.1]
Information in this document applies to any platform.
***Checked for relevance on 11-Oct-2011***

Symptoms

While applying the 11.1.0.7.0 patchset to an 11.1.0.6.0 instance, catupgrd.sql fails with PLS-538 errors on SDO_INDEX_METHOD_10I such as these:

     ...

     SQL> create or replace type body sdo_index_method_10i wrapped
       2  a000000
       3  1
     ...
      71  ah4T5O3OUVnKl7+1RC8ulDA=
      72  
      73  /

     Warning: Type Body created with compilation errors.

     SYS@cdobkup > show errors;
     Errors for TYPE BODY SDO_INDEX_METHOD_10I:

     LINE/COL ERROR
     -------- ---------------------------------------------------------------
     180/56   PLS-00538: subprogram or cursor 'ODCIINDEXREWRITE' is declared
              in an object type specification and must be defined in the
              object type body

     ...

           LINE
     ----------
     TEXT
     ------------------------------------------------------------------------
            180
     PLS-00538: subprogram or cursor 'ODCIINDEXREWRITE' is declared in an
      object
type specification and must be defined in the object type body


     1 row selected.

     ...

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