MDSYS.SDO_GEOMETRY Is Invalid with Compilation Errors PLS-00539 GET_WKB & GET_WKT
(Doc ID 2602007.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 19.3.0.0.0 and laterOracle Spatial and Graph - Version 19.9.0.0.0 to 19.9.0.0.0 [Release 12.2]
Information in this document applies to any platform.
Symptoms
SQL> alter type MDSYS.SDO_GEOMETRY compile body;
Warning: Type Body altered with compilation errors.
SQL> show 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
METHOD
------
MEMBER FUNCTION GET_WKB RETURNS BLOB >>>>>>>>> NOT PRESENT
METHOD
------
MEMBER FUNCTION GET_WKT RETURNS CLOB >>>>>>>>> NOT PRESENT
SQL> desc mdsys.sdo_geometry;
Name Null? Type
----------------------------------------- -------- ----------------------------
SDO_GTYPE NUMBER
SDO_SRID NUMBER
SDO_POINT MDSYS.SDO_POINT_TYPE
SDO_ELEM_INFO MDSYS.SDO_ELEM_INFO_ARRAY
SDO_ORDINATES MDSYS.SDO_ORDINATE_ARRAY
METHOD
------
MEMBER FUNCTION GET_GTYPE RETURNS NUMBER
METHOD
------
MEMBER FUNCTION GET_DIMS RETURNS NUMBER
METHOD
------
MEMBER FUNCTION GET_LRS_DIM RETURNS NUMBER
METHOD
------
MEMBER FUNCTION ST_COORDDIM RETURNS NUMBER
METHOD
------
MEMBER FUNCTION ST_ISVALID RETURNS NUMBER
METHOD
------
MEMBER FUNCTION GET_GML RETURNS CLOB
METHOD
------
MEMBER FUNCTION GET_GML RETURNS CLOB
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
SRSNAMESPACE VARCHAR2 IN
SRSNSALIAS VARCHAR2 IN
METHOD
------
MEMBER FUNCTION GET_GML RETURNS CLOB
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
COORDORDER NUMBER IN
METHOD
------
MEMBER FUNCTION GET_GML RETURNS CLOB
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
SRSNAMESPACE VARCHAR2 IN
SRSNSALIAS VARCHAR2 IN
COORDORDER NUMBER IN
METHOD
------
MEMBER FUNCTION GET_GML311 RETURNS CLOB
METHOD
------
MEMBER FUNCTION GET_GML311 RETURNS CLOB
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
SRSNAMESPACE VARCHAR2 IN
SRSNSALIAS VARCHAR2 IN
METHOD
------
MEMBER FUNCTION GET_GML311 RETURNS CLOB
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
COORDORDER NUMBER IN
METHOD
------
MEMBER FUNCTION GET_GML311 RETURNS CLOB
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
SRSNAMESPACE VARCHAR2 IN
SRSNSALIAS VARCHAR2 IN
COORDORDER NUMBER IN
METHOD
------
MEMBER FUNCTION GET_GML321 RETURNS CLOB
METHOD
------
MEMBER FUNCTION GET_GML321 RETURNS CLOB
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
SRSNAMESPACE VARCHAR2 IN
SRSNSALIAS VARCHAR2 IN
METHOD
------
MEMBER FUNCTION GET_GML321 RETURNS CLOB
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
COORDORDER NUMBER IN
METHOD
------
MEMBER FUNCTION GET_GML321 RETURNS CLOB
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
SRSNAMESPACE VARCHAR2 IN
SRSNSALIAS VARCHAR2 IN
COORDORDER NUMBER IN
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 |