My Oracle Support Banner 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: to - Release: 11.1 to 11.1
Oracle Spatial - Version: to   [Release: 11.1 to 11.1]
Information in this document applies to any platform.
***Checked for relevance on 11-Oct-2011***


While applying the patchset to an 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=
      73  /

     Warning: Type Body created with compilation errors.

     SYS@cdobkup > show errors;

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


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

     1 row selected.



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

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