Google maps API lat/long trigger

gistfile1.sql

CREATE OR REPLACE TRIGGER trg_products_location
BEFORE INSERT OR UPDATE OF postcode ON products FOR EACH ROW
DECLARE
    l_lat VARCHAR2(100);
    l_lng VARCHAR2(100);
BEGIN
    brian.POSTCODE_TO_LAT_LNG_GM_API(:NEW.POSTCODE, l_lat, l_lng);
  
    :NEW.LOCATION := SDO_GEOMETRY(2001, -- SDO_GTYPE
        8307, -- SDO_SRID
        SDO_POINT_TYPE(
            l_lng,  -- X longitude
            l_lat,  -- Y latitude
            null    -- Z, not needed for 2D location
        ),  
        null, -- SDO_ELEM_INFO_ARRAY
        null
    ); -- SDO_ORDINATE_ARRAY
END;