What is one possible explanation?

Posted on 2001-07-17
Last Modified: 2008-02-20
The database has reported the error 'ORA-04091: table <table_name> is mutating, trigger/function may not see it'. What is one possible explanation?  
Choice 1  
 A statement trigger fired by your statement has executed an improperly formed SELECT, resulting in a large cartesian product.  
Choice 2  
 A statement trigger fired by your statement has attempted to select from its triggering table.  
Choice 3  
 You have attempted to change a table currently being updated by a row trigger fired by another user.  
Choice 4  
 A row trigger fired by your statement has attempted to access its triggering table.  
Choice 5  
 Another user has changed a table referenced by a row trigger fired by your statement.  
Question by:Daman

Expert Comment

ID: 6289420

Accepted Solution

alx512 earned 0 total points
ID: 6289772

Expert Comment

ID: 6289797

Expert Comment

ID: 6293037
Hello Daman

I would like to point you to the member agreement. You can find a link to that on the bottom of every page.

Specifically the Guidelines for use, in which it states that Experts Exchange shall not be used for

* violating the guidelines for academic honesty or other unethical behavior.

In other words:

Experts-Exchange is not a homework service. Please stop using it for this purpose.

alx512, I've reduced the points to this question to zero. As you can see you will not get any points for your help.

Community Support Moderator@Experts-Exchange

Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Create table from select - oracle 6 68
Oracle Listener Not Starting 11 65
Oracle encryption 12 59
subtr returning incorrect value 8 65
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

756 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