I would like to user a trigger to call a procedure, mostly to make to code that I would have put in the trigger alone, non-hidden (i.e. I want the fact that there is code affecting that function to be available in the list with the other code that is in the stored prodecure area).
My question is, in a trigger, one can set rollback for certain conditions etc., if those conditions are found in the called procedure, will the rollback still rollback the update / insert in the table, since the focus would no longer be inside the trigger?
Also, can values be pulled from the inserted table in a procedure called from a trigger?
Thank You
Rollin Burr
Politicians and diapers have one thing in common. They should both be changed regularly, and for the same reason.