ORA-13199: Polygon Rings exceed half the area of earth when running query with SVA=FALSE (Doc ID 2251459.1)

Last updated on APRIL 08, 2022

Applies to:

Symptoms

On 12.1.0.2 version, when attempting to run with SVA=FALSE

select
SDO_GEOM.RELATE(g1,'equal',g2,0.00005) g_equal
,SDO_GEOM.VALIDATE_GEOMETRY_WITH_CONTEXT(g1,0.00005) g1_valid
,SDO_GEOM.VALIDATE_GEOMETRY_WITH_CONTEXT(g2,0.00005) g2_valid
,sdo_geom.sdo_union(g1,g2,0.00005) g_union
from
(select
MDSYS.SDO_GEOMETRY(2003,NULL,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1005,8,1,2,2,5,2,1,7,2,2,11,2,1,13,2,2,17,2,1,19,2,2,27,2,1),MDSYS.SDO_ORDINATE_ARRAY(538859.446609,186738.55339,538713.581583063,186409.109091293,538827.034882,186067.146373,538841.034882,186050.146373,539362.058075573,185886.58612716,539721.974746,186297.28932,539722.974746,186304.28932,539708.060078828,186514.793823589,539607.628301,186700.395686,539601.628301,186707.395686,539558.000874019,186752.274769982,539509.108343,186791.351681,539175.903388621,186885.469109127,538861.446609,186740.55339,538859.446609,186738.55339)) g1, MDSYS.SDO_GEOMETRY(2003,NULL,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1005,8,1,2,2,5,2,1,7,2,2,11,2,1,13,2,2,17,2,1,19,2,2,27,2,1),MDSYS.SDO_ORDINATE_ARRAY(538859.446609407,186738.553390593,538713.581586549,186409.109091762,538827.034882191,186067.146373569,538841.034882191,186050.146373569,539362.058076508,185886.586128191,539721.974746831,186297.289321881,539722.974746831,186304.289321881,539708.060085788,186514.793826879,539607.628301183,186700.395686728,539601.628301183,186707.395686728,539558.000878986,186752.274775431,539509.108343754,186791.351681256,539175.903389124,186885.469111398,538861.446609407,186740.553390593,538859.446609407,186738.553390593)) g2
from dual
union all
select
MDSYS.SDO_GEOMETRY(2003,NULL,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1005,8,1,2,2,9,2,1,11,2,2,15,2,1,17,2,2,21,2,1,23,2,2,27,2,1),MDSYS.SDO_ORDINATE_ARRAY(331834.799134,398966.348646,331645.787801038,398668.189821183,331700.846129,398319.488589,332034.868100793,398057.237979048,332450.068811,398146.425592,332452.448814,398148.235592,332610.499969353,398351.959583836,332646.029776,398607.344128,332643.839776,398625.124124,332610.494230914,398752.99647521,332544.813418,398867.666848,332539.003418,398875.26685,332209.8410677,399066.946026041,331841.179134,398971.148646,331834.799134,398966.348646)) g1,

MDSYS.SDO_GEOMETRY(2003,NULL,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1005,8,1,2,2,9,2,1,11,2,2,15,2,1,17,2,2,21,2,1,23,2,2,27,2,1),MDSYS.SDO_ORDINATE_ARRAY(331834.799137126,398966.3486469,331645.787802479,398668.189822164,331700.846129905,398319.488589051,332034.868104357,398057.237984729,332450.068814321,398146.425592218,332452.448814321,398148.235592218,332610.499970124,398351.959584246,332646.029776697,398607.344128851,332643.839776697,398625.124128851,332610.494234702,398752.996480112,332544.813418411,398867.666850126,332539.003418412,398875.266850126,332209.841070355,399066.946031277,331841.179137126,398971.1486469,331834.799137126,398966.3486469)) g2
from dual) tbl;


the following error occurs.

ERROR
-----------------------
ERROR:
ORA-13199: Polygon Rings exceed half the area of earth
ORA-06512: at "MDSYS.SDO_3GL", line 1793
ORA-06512: at "MDSYS.SDO_3GL", line 1924
ORA-06512: at "MDSYS.SDO_GEOM", line 1470
ORA-06512: at "MDSYS.SDO_GEOM", line 1637

no rows selected

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.