This is my first foray into triggers and I would appreciate help. This is what I have done:

I have 2 stored procedures:  demo3 and demo3b

what I want to do is capture the updated row before it is updated and after it is updated. the before and after are inserted into table Emp_Tracker

alter table employee add trigger update demo3
when I list triggers, it shows up as an update trigger

alter table employee add trigger update after demo3b
list triggers and get:
update trigger: No Trigger Defined
After Update Trigger: demo3b

Why did the update trigger demo3  disappear?

Both of these triggers fire correctly when I do them one at a time.

Bernie Lis



Reply via email to