Forum Discussion
briano_o
Dec 28, 2023Copper Contributor
Calling stored procedures within trigger
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?
- olafhelperBronze Contributor
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.