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

    JJE

      Hello everybody,

       

      The following query returns NULL in Oracle 11.2.0.4:

       

      SELECT SDO_GEOM.SDO_DISTANCE(

      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.