-
triggers
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|