5 Replies Latest reply on Jan 11, 2017 7:52 AM by Stefan Jager

    3D compound line string gives ERROR 54530

    user8048037

      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;