My Oracle Support Banner

MDSYS.SDO_GEOMETRY Is Invalid with Compilation Errors PLS-00539 GET_WKB & GET_WKT (Doc ID 2602007.1)

Last updated on APRIL 24, 2020

Applies to:

Oracle Database - Enterprise Edition - Version 19.3.0.0.0 and later
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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.