I have created a trigger, but new values are not getting in the backup table. I am given this statement. Please help me.

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);

    Requires Free Membership to View

Your code above does not have the following lines:

END;
/

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.

This was first published in January 2008

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: