How to avoid ‘mutating table’ errors

By Pravesh Gupta – Sometimes you may need to do an insert or update in the same table on which your trigger fires, resulting in a “Mutating Table” error. This can be avoided by writing a procedure, function or package that declares the pragma autonomous_transaction. The transaction is thus not visib

Read More - Register for Free Membership