Hi,

First of all, I am not a trained DBA, so I am not sure if I am even doing this right. That being said, I have to do it.

I am trying to create a trigger to monitor when something is deleted from the database, and have it insert in a table what was deleted and give a timestamp and date...

create or replace
TRIGGER
"TRIGGERACCESSPOINT" AFTER DELETE ON SECOMORA.ACCESS_POINT@ospi
BEGIN
INSERT INTO DELITM_TABLE (NAME, WHEN) VALUES ('Access Point');
END;

this is what I have so far. though I am getting errors. ORA-00947: not enough values, I think I understand that it means since I have two columns that I need another value. I am just not sure what to put there so that I can get the time and date the event occurred.

Thanks in advance for any help
Ryvur