Identify which set of coordinates is within a radius in the ORACLE base

Question

Hello personal I have a script here in Mysql, however I need to apply it in an Oracle database,

SELECT *,(RAIO_TERRESTRE * 
    acos(
     cos(radians(PARAMETRO_LATITUDE)) * 
     cos(radians(COLUNA_LATITUDE)) * 
     cos(radians(PARAMETRO_LONGITUDE) - radians(COLUNA_LONGITUDE)) + 
     sin(radians(PARAMETRO_LATITUDE)) * 
     sin(radians(COLUNA_LATITUDE))
  )) AS CAMPOLATITUDE
FROM TABELA HAVING CAMPOLATITUDE <= KM

---

EXAMPLE:

SELECT *, (6371 *
        acos(
            cos(radians(-19.83996)) *
            cos(radians(lat)) *
            cos(radians(-43.94910) - radians(lng)) +
            sin(radians(-19.83996)) *
            sin(radians(lat))
        )) AS distance
FROM tabela HAVING distance <= 5

what this script does and the following:

I have an ORACLE database with latitude (lat) and longitude (lng) coordinates and am passing the one reference point (in the example the values -19.83996 and 43.94910). With this I get all the places that are at a distance of 5 Km from the reference point. However this script is in Mysql and I tried to apply it in Oracle but it presents errors.