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

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.