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
"TRIGGERACCESSPOINT" AFTER DELETE ON SECOMORA.ACCESS_POINT@ospi
INSERT INTO DELITM_TABLE (NAME, WHEN) VALUES ('Access Point');
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
Click Here to Expand Forum to Full Width