Ask the Expert

Writing an ON INSERT trigger without encountering mutating table error

Is there a way to write a database trigger on a table ON INSERT without encountering the ERROR ORA-04091 (mutating table state)?

    Requires Free Membership to View

I'll refer you to the following link(s) for several answers previously given in this forum to the mutating table problem. One or all should give you the info you need!
http://searchdatabase.techtarget.com/search/1,293876,sid13,00.html?filter=on&query=mutating%20table&ctype=ADVICE&within=text

For More Information


This was first published in September 2002

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: