Jamie Carruthers
Jamie Carruthers

Reputation: 685

Trigger preventing insert

Is there any reason that having a trigger on a table would prevent the original insert statement from inserting? The trigger is run AFTER the row is inserted in the table, and there is no transaction rollback in the trigger.

Upvotes: 1

Views: 343

Answers (1)

tpeczek
tpeczek

Reputation: 24125

It will happen when there is an exception in the trigger (when an error happens in a trigger the batch is aborted).

Upvotes: 3

Related Questions