Trigger to populate latitude and longitude columns

Hi, I am working with Oracle Enterprise Spatial 10.2.0.4.

I am trying to create a trigger to populate the latitude and longitude fields in a table called PH_WMV_MOSQ_TRAPS on insert and update. Here is what I created:

create or replace
TRIGGER TRG_PH_WNV_MTRAPS_COORD
 BEFORE INSERT OR UPDATE OF GEOMETRY ON PH_WNV_MOSQ_TRAPS
FOR EACH ROW
DECLARE
    SSQL1  VARCHAR2(255);
    SSQL2  VARCHAR2(255);
    iLAT NUMBER(10,6);
    iLONG NUMBER(10,6);
 
BEGIN
    sSql1 := 'SELECT getlatlon(GEOMETRY).sdo_point.x FROM PH_WNV_MOSQ_TRAPS';
    EXECUTE IMMEDIATE
    SSQL1 INTO ILONG;
    :NEW.LONGITUDE := ILONG;
    SSQL2 := 'SELECT GETLATLON(GEOMETRY).SDO_POINT.Y FROM PH_WNV_MOSQ_TRAPS';