Forum Stats

  • 3,769,286 Users
  • 2,252,943 Discussions
  • 7,874,980 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.