Before insert or update Trigger
535089Jan 23 2007 — edited Jan 24 2007Hi All,
I have a trigger to update two columns in a table whose event type is "before insert or update for each row". The values to this table is inserted through a procedure.
I insert values to these two columns through the procedure as well. But these values gets over written by the trigger values. How come the values are getting overwritten by the trigger when the event type for this trigger is "before insert or update" ?
My requirement is to have the trigger but when I insert the value through this procedure, the value should be the one from the procedure instead of the trigger values.
Please help. let me know if I am not clear.