SDO GEOM.VALIDATE GEOMETRY Fails To Identify Wrongly Orientated Geometry (Doc ID 1609111.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Spatial and Graph - Version 10.2.0.4 to 12.1.0.1 [Release 10.2 to 12.1]
Information in this document applies to any platform.

Symptoms

SDO GEOM.VALIDATE_GEOMETRY fails to identify wrongly oriented geometry


SELECT SDO_GEOM.VALIDATE_GEOMETRY_WITH_CONTEXT
  (
  MDSYS.SDO_GEOMETRY
  ( 2003,81989,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1)
  , MDSYS.SDO_ORDINATE_ARRAY
  ( 360317.599, 609978.98
  , 360317.576, 609978.984
  , 360317.577, 609978.984
  , 360317.599, 609978.98
  )
  )
  , 0.0000000005
  ) AS Clockwise
FROM DUAL;


The function fails to return ORA-13367 (wrong orientation for
interior/exterior rings) for the Clockwise oriented geometry.

The Geometry is invalid. VALIDATE_GEOMETRY_WITH_CONTEXT should identify it as
such.

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