开发者

Does After Delete trigger result in Mutating table?

I read somewhere that solution to mutating table is to use After Delete trigger. I开发者_StackOverflows this correct?


No it is not correct, and an AFTER DELETE, FOR EACH ROW trigger can result in the "Table is mutating" error. The solution is not to perform an operation against the same table in a FOR EACH ROW trigger defined on that table. Tom Kyte has documented a method for avoiding this issue here on AskTom.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜