Type Body MDSYS.SDO_GEOMETRY Is Invalid
(Doc ID 461508.1)
Last updated on JUNE 30, 2023
Applies to:
Oracle Spatial and Graph - Version 10.1.0.2 to 10.1.0.3 [Release 10.1]Information in this document applies to any platform.
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 |