SDO_UTIL.TO_WKTGEOMETRY FAILS "FOR GTYPE_MULTICURVE, INTERPRETATION SHOULD BE 1

(Doc ID 2399973.1)

Last updated on MAY 17, 2018

Applies to:

Oracle Spatial and Graph - Version 11.2.0.4 and later
Information in this document applies to any platform.

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  validate fine.

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 occur on objects of Gtype 2006 (multicurve).

Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms