pass parameters to a trigger
Posted on 2006-05-08
I was wondering if anyone found a way to pass parameters to a trigger from a procedure calling the update / delete / insert statement.
I want this because my trigger does things it needs to do almost always, but... some procedures need to update a table without calling the trigger, or even better, somehow set a param that the trigger checks, and acts depending on the value of the param.
I do not want to use a field in the table to achief this!
Any thoughts welcom