What are mutating tables? And what is mutating error?
A mutating table is a table that is currently being modified by an UPDATE, DELETE, or INSERT statement, or it is a table that might need to be updated by the effects of a declarative DELETE CASCADE referential integrity constraint. A mutating error occurs when a trigger which fires when updation/deletion/insertion is done on a table A performs insertion/updation/deletion on the same table A. This error results in an infinite loop which is termed as a mutating error.
Related Questions
- I am attempting to create a relationship between two tables in Access, but keep getting a type mismatch error, every time I attempt to run the query. What is the problem?
- I have some tables that have an Incorrect record length error when I insert them in the BOM File Maintenance window. How can I correct that?
- What are mutating tables? And what is mutating error?
