SDO_UTIL.SIMPLIFY NOT PRODUCING GEOMETRY WITH VERY SMALL THRESHOLD (Doc ID 1440387.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Spatial - Version: 10.2.0.5.0 to 11.2.0.2 - Release: to 11.2
Information in this document applies to any platform.

Symptoms

The purpose of Oracle Spatial sdo_util.simplify is to have a geometry with less vertices. Yet, function sdo_util.simplify returns an error when trying to simplify a geometry
using very small threshold,  for example, when running:

select sdo_util.simplify(geometry, 1e-9 * 200 * 1, 1e-9) from sample_geometry; -- Function returns an error!

All versions below 11.2.0.3 are confirmed as being affected. Bug is fixed on 11.2.0.3

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