Select Query Uses SDO_UTIL.RECTIFY_GEOMETRY Function Throws ORA-13199: the given geometry cannot be rectified
(Doc ID 1638262.1)
Last updated on AUGUST 04, 2018
Applies to:Oracle Database - Enterprise Edition - Version 220.127.116.11 and later
Information in this document applies to any platform.
While running following select query failed with following errors in 12.1 but these query are working fine in 11g:
SELECT SDO_UTIL.RECTIFY_GEOMETRY(geom,0.05) FROM TEST_TABLE;
SELECT SDO_GEOM.VALIDATE_GEOMETRY_WITH_CONTEXT(SDO_UTIL.RECTIFY_GEOMETRY(geom,0.05),0.05) FROM TEST_TABLE;
ERROR at line 1:
ORA-13199: the given geometry cannot be rectified
ORA-06512: at "MDSYS.MD", line 1723
ORA-06512: at "MDSYS.MDERR", line 17
ORA-06512: at "MDSYS.SDO_UTIL", line 803
This is an effect on the improved geodetic geometry validation in 18.104.22.168.
The two geometries that do not rectify (id 15456 and 18710) were categorized as valid in 11g .
In 12c, improved validation now returns:
SELECT id, SDO_GEOM.VALIDATE_GEOMETRY_WITH_CONTEXT(geom,0.05)
WHERE id in (15456,18710);
15456 13350 [Element <189>] [Ring <1>][Edge <77>] [Element <623>] [Ring <1>][Edge <1>]
18710 13350 [Element <1>] [Rings 1, 53][Edge <1486> in ring <1>][Edge <17> in ring <53>]
In 11g, there was no need to rectify these two geometries because they were valid.
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