11gR2: java exception for function SDO_UTIL.TO_WKTGEOMETRY and method GetWKT - CLOSED COMPOUNDCURVE
Hello all,
v_geom1 sdo_geometry;
v_geom2 sdo_geometry;
v_WKT clob;beginv_geom1 := sdo_geometry(2003, null, null, sdo_elem_info_array(1,5,8,1,2,1,3,2,2,7,2,1,9,2,2,13,2,1,15,2,2,19,2,1,21,2,2),
sdo_ordinate_array(-613140, -1056865, -613140, -1056875, -613138.535533906, -1056878.53553391, -613135, -1056880, -613125, -1056880,
-613121.464466094, -1056878.53553391, -613120, -1056875, -613120, -1056865, -613121.464466094, -1056861.46446609, -613125, -1056860,
-613135, -1056860, -613138.535533906, -1056861.46446609, -613140, -1056865)); v_geom2 := sdo_geometry(2002, null, null, sdo_elem_info_array(1,4,8,1,2,1,3,2,2,7,2,1,9,2,2,13,2,1,15,2,2,19,2,1,21,2,2),
sdo_ordinate_array(-613140, -1056865, -613140, -1056875, -613138.535533906, -1056878.53553391, -613135, -1056880, -613125, -1056880,
-613121.464466094, -1056878.53553391, -613120, -1056875, -613120, -1056865, -613121.464466094, -1056861.46446609, -613125, -1056860,
-613135, -1056860, -613138.535533906, -1056861.46446609, -613140, -1056865)); dbms_output.put_line(sdo_geom.validate_geometry_with_context(v_geom1, 0.0005));dbms_output.put_line(sdo_geom.validate_geometry_with_context(v_geom2, 0.0005));dbms_output.put_line(v_geom1.GET_WKT()); --Java Error
I found some error from java source in DB for getting WKT text from a geometry. Why closed compoundcurve generates this error? I use database version 11.2.0.3.
TestCase:
declarev_geom1 sdo_geometry;
v_geom2 sdo_geometry;
v_WKT clob;beginv_geom1 := sdo_geometry(2003, null, null, sdo_elem_info_array(1,5,8,1,2,1,3,2,2,7,2,1,9,2,2,13,2,1,15,2,2,19,2,1,21,2,2),
sdo_ordinate_array(-613140, -1056865, -613140, -1056875, -613138.535533906, -1056878.53553391, -613135, -1056880, -613125, -1056880,
-613121.464466094, -1056878.53553391, -613120, -1056875, -613120, -1056865, -613121.464466094, -1056861.46446609, -613125, -1056860,
-613135, -1056860, -613138.535533906, -1056861.46446609, -613140, -1056865)); v_geom2 := sdo_geometry(2002, null, null, sdo_elem_info_array(1,4,8,1,2,1,3,2,2,7,2,1,9,2,2,13,2,1,15,2,2,19,2,1,21,2,2),
sdo_ordinate_array(-613140, -1056865, -613140, -1056875, -613138.535533906, -1056878.53553391, -613135, -1056880, -613125, -1056880,
-613121.464466094, -1056878.53553391, -613120, -1056875, -613120, -1056865, -613121.464466094, -1056861.46446609, -613125, -1056860,
-613135, -1056860, -613138.535533906, -1056861.46446609, -613140, -1056865)); dbms_output.put_line(sdo_geom.validate_geometry_with_context(v_geom1, 0.0005));dbms_output.put_line(sdo_geom.validate_geometry_with_context(v_geom2, 0.0005));dbms_output.put_line(v_geom1.GET_WKT()); --Java Error
0