My Oracle Support Banner

Type Body MDSYS.SDO_GEOMETRY Is Invalid (Doc ID 461508.1)

Last updated on JANUARY 03, 2018

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

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.