sdo_nn_distance returning 0 19c

User_GK50K

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.