This site is currently read-only as we are migrating to Oracle Forums for an improved community experience. You will not be able to initiate activity until January 31st, when you will be able to use this site as normal.

    Forum Stats

  • 3,890,732 Users
  • 2,269,776 Discussions
  • 7,916,827 Comments

Discussions

sdo_nn_distance returning 0 19c

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';


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.