/* Calculating the distance from the location points given in the input against the table */ STRING_STR:= 'SELECT NEW ST_Point(''POINT (' || :Latitude ||' ' || :Longitude || ')'',4326).ST_Distance(LongLat)/1000 AS "Distance(KM)" FROM CITY WHERE id = 2'; EXECUTE IMMEDIATE ...