Skip to Main Content

Oracle Database Discussions

Announcement

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

sdo_nn_distance returning 0 19c

User_GK50KSep 17 2021

Hi all,
Im using sdo_nn_distance function.
In 12c Im having proper response while in 19c the sdo_nn_distance is returning 0 for all columns.
I didn't made any data changes.
query below:

SELECT /*+ ordered use_nl(cb) index(cb idx1_city_bourder_geo_idx) */ CB.CITY_ID, SDO_NN_DISTANCE(1)
  FROM CITY_BOURDER CB
 WHERE SDO_NN(CB.BOUNDARY, MDSYS.SDO_GEOMETRY(2001, 4326, MDSYS.SDO_POINT_TYPE(IN_LON, IN_LAT, NULL), NULL, NULL), 'sdo_batch_size=3', 1) = 'TRUE';

Im not receiving any errors, column for sdo_nn_distance result is 0.
I have gone through documentation, I couldn't find anything related Spatial ,changes https://docs.oracle.com/en/database/oracle/oracle-database/19/spatl/spatial-and-graph-developers-guide.pdf.
I have spatial package only versions are different.
Using sdo_distance is solving the issue but since there is specific feature is defined (sdo_nn_distance) I would like to use it. In spatial studio I didn't came across this function is it removed?
Thank you for your supports.

Comments
Post Details
Added on Sep 17 2021
0 comments
114 views