Forum Discussion

briano_o's avatar
briano_o
Copper Contributor
Dec 28, 2023

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?

 

 

 

 

  • olafhelper's avatar
    olafhelper
    Bronze 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.

Resources