How do I troubleshoot ORA-04091 error during a script execution

Posted on 2009-04-28
Last Modified: 2013-12-18
ORA-04091: table SG_ADM.BIB_HOLDINGS is mutating, trigger/function may not see it

ORA-06512: at "SG_ADM.TRIG_MP_MIGRATION", line 9

ORA-04088: error during execution of trigger 'SG_ADM.TRIG_MP_MIGRATION'

ORA-06512: at "SG_ADM.RWT_BIB_HOLDINGS", line 46

ORA-04088: error during execution of trigger 'SG_ADM.RWT_BIB_HOLDINGS'

Question by:sikyala
    1 Comment
    LVL 29

    Accepted Solution


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
    From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
    This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
    This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now