SDO_UTIL.TO_WKTGEOMETRY FAILS "FOR GTYPE_MULTICURVE, INTERPRETATION SHOULD BE 1 (Doc ID 2399973.1)

Last updated on APRIL 08, 2022

Applies to:

Symptoms

The following error is being generated when trying to convert a column of the SDO Geometry data type to well-known text (WKT) format, using the SDO_UTIL.TO_WKTGEOMETRY function.

SQL> SELECT GID,  SDO_UTIL.TO_WKTGEOMETRY(T.GEOMETRY)
GEOMETRY_WKT, T.GEOMETRY.SDO_SRID GEOMETRY_SRID FROM SP_TEST T
3 /
ERROR:
ORA-29532: Java call terminated by uncaught Java exception:
java.lang.RuntimeException: oracle.spatial.util.GeometryExceptionWithContext:
For GTYPE_MULTICURVE, interpretation should be 1 or 2
ORA-06512: at "MDSYS.SDO_UTIL", line 2679
ORA-06512: at "MDSYS.SDO_UTIL", line 2703

Executing SDO_GEOM.VALIDATE_GEOMETRY_WITH_CONTEXT against the rows generating the above error validates without error.

SQL> select sdo_geom.validate_geometry_with_context(T.GEOMETRY,m.diminfo)
Valid from SP_TEST T,user_sdo_geom_metadata m where
m.table_name='SP_AD_GEOM'
2 /

VALID
--------------------------------------------------------------------------------
TRUE

The issue only occurs on objects of Gtype 2006 (multicurve).

Changes

Cause

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