My Oracle Support Banner

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

Last updated on MAY 31, 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 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

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
Changes
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.