Upgrade To 10.2.0.4 Shows Errors Like ORA-29831 And PLS-306 For Spatial Objects (Doc ID 605366.1)

Last updated on MARCH 02, 2010

Applies to:

Oracle Spatial - Version: 10.2.0.4
Information in this document applies to any platform.

Symptoms

Upgrading from V10.2.0.2 or V10.2.0.3 to V10.2.0.4 shows numerous error messages during the Step 'Upgrading Oracle InterMedia', like:

ORA-29831: operator binding not found ORA-06553: PLS-306: wrong number or types of arguments in call to 'SDO_INSIDE'

Those messages are related to Spatial actions like:

alter indextype spatial_index drop 
     sdo_anyinteract(mdsys.sdo_topo_geometry, mdsys.sdo_topo_geometry);
sdo_anyinteract(mdsys.sdo_topo_geometry, mdsys.sdo_topo_geometry)
*
ERROR at line 2:
ORA-29831: operator binding not found
ORA-06553: PLS-306: wrong number or types of arguments in call to 'SDO_ANYINTERACT'

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