Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.4K Intelligent Advisor
- 75 Insurance
- 537.6K On-Premises Infrastructure
- 138.7K Analytics Software
- 38.6K Application Development Software
- 6.1K Cloud Platform
- 109.6K Database Software
- 17.6K Enterprise Manager
- 8.8K Hardware
- 71.3K Infrastructure Software
- 105.4K Integration
- 41.6K Security Software
3D compound line string gives ERROR 54530

Why is the 2D compound line string valid, but the 3D one is not (ORA 11.2.0.3)?
--validates TRUE
SELECT sdo_geom.validate_geometry_with_context( SDO_GEOMETRY(2002,NULL,NULL, SDO_ELEM_INFO_ARRAY(1,4,2, 1,2,1, 3,2,2), SDO_ORDINATE_ARRAY( 10,10, 10,14, 6,10, 14,10)),0.001) FROM dual;
--validates 54530 Point:0,Edge:1,
SELECT sdo_geom.validate_geometry_with_context( SDO_GEOMETRY(3002,NULL,NULL, SDO_ELEM_INFO_ARRAY(1,4,2, 1,2,1, 4,2,2), SDO_ORDINATE_ARRAY( 10,10,0, 10,14,0, 6,10,0, 14,10,0)),0.001) FROM dual;
Answers
-
Get the same error in ORA 12.1.0.2.0.
Is this possibly because we have no Spatial license? Could someone with Spatial license test it please.
Thanks a lot.
-
It seems to be a bug. Please ask oracle support to file a bug.
-
It doesn't seem to make a difference (I get the same error as you do even when I modify the 3D geometry), but your geometries are not the same, notably the element info:
SDO_ELEM_INFO_ARRAY(1,4,2, 1,2,1, 3,2,2),
and
SDO_ELEM_INFO_ARRAY(1,4,2, 1,2,1, 4,2,2),
note the 4 in the last triplet. On my 11.2 it doesn't make a difference in the validation however.
Regards,
Stefan
-
Thank you Stefan, for your note:
..., but your geometries are not the same, notably the element info: SDO_ELEM_INFO_ARRAY(1,4,2, 1,2,1, 3,2,2),and SDO_ELEM_INFO_ARRAY(1,4,2, 1,2,1, 4,2,2), note the 4 in the last triplet. ...
The info_array has to be different imo, because now it is a 3D geometry.
So the second part of the compound line string (ARC) now starts a the 4th ordinate, because of the additional z=0:
SDO_ORDINATE_ARRAY(
10,10,0,
10,14,0,
6,10,0,
14,10,0)
-
Duh. Sorry, my bad, you're completely right. Still in Openlayers mode (coordinates instead of ordinates), which is what I've been playing with mostly the past couple of days.
And possibly not enough coffee ...