Problem with sdo_geom.validate_geometry_with_context() in 10.2.0.4
sdo_geom.validate_geometry_with_context()
This is a simple test of one element that reproduces the error:
/***************************************************************************************************/
create table test_poly (ID number(2,0) primary key, GEOMETRY mdsys.sdo_geometry);
insert into test_poly values(
1,
SDO_GEOMETRY(
2003,
8307,
NULL,
SDO_ELEM_INFO_ARRAY(1,1003,1, 11,2003,1),
sdo_ordinate_array(
-5.98129,37.38084, -5.98109,37.3807 , -5.98093,37.38069, -5.98091,37.38091, -5.98129,37.38084,
-5.98109,37.3808 , -5.98098,37.38082, -5.98098,37.38073, -5.98101,37.38073, -5.98109,37.3808
)
)
);
INSERT INTO user_sdo_geom_metadata values(
'TEST_POLY',
'GEOMETRY',
SDO_DIM_ARRAY(
SDO_DIM_ELEMENT('LON',-5.98129,-5.98091,0.0000001), SDO_DIM_ELEMENT('LAT',37.38069,37.38091,0.0000001)