Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SDO_GEOM.SDO_DISTANCE returns NULL when executed for 3 dimensional geometries

JJEOct 24 2013 — edited Oct 28 2013

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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 25 2013
Added on Oct 24 2013
#11g, #database-key-features, #query, #spatial
4 comments
2,398 views