create or replace trigger "SUPPQUOTES_AUDIT" after update or delete on phsuppquotes for each row begin insert into
phquotes_audit(cprc_new,suppcode,itemcode,cprc_old,negodt,validdt,userid,TRANDATE) values (:new.cprc,:old.suppcode,:old.itemcode,:old.cprc,:old.negodt,:old.validdt,:old.userid,SYSDATE);
That may just be an oversight, however.
When you update or delete a record on the phsuppquotes table, what error, if any are you getting? There could be many reasons why your trigger is not working correctly, so error message help. Also, ensure the trigger is firing by changing your INSERT statement to insert just some dummy literal values instead of variable values and then test.
Dig deeper on Oracle database administration
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.