Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

3D compound line string gives ERROR 54530

user8048037Dec 22 2016 — edited Jan 11 2017

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;

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 8 2017
Added on Dec 22 2016
5 comments
781 views