SDO_UTIL.RECTIFY_GEOMETRY Returns Empty Geometry Instead Of Exception (Doc ID 1326035.1)

Last updated on MAY 27, 2011

Applies to:

Oracle Spatial - Version: 11.1.0.6 to 11.1.0.6 - Release: 11.1 to 11.1
Information in this document applies to any platform.

Symptoms

SDO_UTIL.RECTIFY_GEOMETRY returns an empty geometry instead of an exception when the input geometry cannot be fixed. For example:

SQL> select sdo_geom.validate_geometry_with_context(shape, 0.05)
  2    from test;

SDO_GEOM.VALIDATE_GEOMETRY_WITH_CONTEXT(SHAPE,0.05)
----------------------------------------------------------------------------------------------------
13350 [Element <31>] [Rings 1, 2][Edge <18> in ring <1>][Edge <7> in ring <2>]

SQL> select sdo_util.rectify_geometry(shape, 0.05)
  2    from test;

SDO_UTIL.RECTIFY_GEOMETRY(SHAPE,0.05)(SDO_GTYPE, SDO_SRID, SDO_POINT(X, Y, Z), SDO_ELEM_INFO,
----------------------------------------------------------------------------------------------------


SQL> select sdo_geom.validate_geometry_with_context(shape, 0.05)
  2    from test2;

SDO_GEOM.VALIDATE_GEOMETRY_WITH_CONTEXT(SHAPE,0.05)
----------------------------------------------------------------------------------------------------
NULL

SQL> select sdo_util.rectify_geometry(shape, 0.05)
  2    from test2;

SDO_UTIL.RECTIFY_GEOMETRY(SHAPE,0.05)(SDO_GTYPE, SDO_SRID, SDO_POINT(X, Y, Z), SDO_ELEM_INFO,
----------------------------------------------------------------------------------------------------


SQL>

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