4 Replies Latest reply: Oct 28, 2013 9:28 AM by _jum RSS

    SDO_GEOM.SDO_DISTANCE returns NULL when executed for 3 dimensional geometries


      Hello everybody,


      The following query returns NULL in Oracle



      SDO_GEOMETRY(    3001,    31370, SDO_POINT_TYPE(100,100, 0),    NULL,    NULL),

      SDO_GEOMETRY(    3001,    31370, SDO_POINT_TYPE(200,200, 1000),    NULL,    NULL),

      0.005) dist from dual


      while SDO_DISTANCE should be supported for 3 dimensional data?


      I would be happy to know if this is a known issue?


      Many thanks.