Re: update trigger only on certain changed values
Posted by:
Bob Field
Date: May 12, 2006 01:08PM
Try commenting out all of the IF stuff at the top, artificially setting stat to some value, see if it inserts rows then, then you know the trigger did fire. Gradually uncomment as you test to find out where the logic problem is (if there is one, and it's not a case of the trigger not being invoked for some reason). Consider declaring stats to be a local variable.
Subject
Views
Written By
Posted
3792
May 12, 2006 11:20AM
Re: update trigger only on certain changed values
1922
May 12, 2006 01:08PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.