Calling stored procedures within trigger

Copper Contributor

 

I executed stored procedures within trigger, but it didn't work.

I searched online to solve the problem and I found some people solved it by adding "set xact_abort off" phrase in the beginning of trigger query.

In my case, It worked too, but I don't understand why it worked.

Do I have to use set xact_abort off to call stored procedures within trigger?

 

 

 

 

1 Reply

I executed stored procedures within trigger, but it didn't work.

@briano_o , "not work" means what in detail (we can't guess that)? Do you get an error message and if, which one?

You have to provide much more details.