Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Trigger Question - New to PL/SQL

user2811127Feb 15 2013 — edited Feb 19 2013
I have a before trigger on a Oracle 11g table that allows me to audit the table to see who is changing data by saving the old value in a variable and logging it along with the new variable and more data into a table. My issue is sometimes_ the trigger does not fire when it meets the criteria. Does anyone have any idea why this would happen or not happen? Thanks in advance for your assistance.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 19 2013
Added on Feb 15 2013
24 comments
1,205 views