Type Body MDSYS.SDO_GEOMETRY Is Invalid

(Doc ID 461508.1)

Last updated on JUNE 29, 2012

Applies to:

Oracle Spatial - Version 10.1.0.2 to 10.1.0.3 [Release 10.1]
Information in this document applies to any platform.
***Checked for relevance on 15-Nov-2010***


Symptoms

After installing the Spatial option into an existing database, the body of type MDSYS.SDO_GEOMETRY  may be invalid and can't be compiled:

SQL> alter type MDSYS.SDO_GEOMETRY compile body

Warning: Type Body altered with compilation errors.

Errors for type body MDSYS.SDO_GEOMETRY:

LINE/COL ERROR
-------- -----------------------------------------------------------------
27/19 PLS-00539: subprogram 'GET_WKB' is declared in an object type
body and must be defined in the object type specification

33/19 PLS-00539: subprogram 'GET_WKT' is declared in an object type
body and must be defined in the object type specification

39/19 PLS-00539: subprogram 'ST_COORDDIM' is declared in an object type
body and must be defined in the object type specification

45/19 PLS-00539: subprogram 'ST_ISVALID' is declared in an object type
body and must be defined in the object type specification


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