My Oracle Support Banner

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 MARCH 28, 2019

Applies to:

Oracle Spatial and Graph - Version 11.1.0.6 to 11.1.0.7 [Release 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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.