Solved

What is one possible explanation?

Posted on 2001-07-17
4
1,024 Views
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.  
0
Comment
Question by:Daman
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
4 Comments
 
LVL 2

Expert Comment

by:RMZ
ID: 6289420
[modder]
0
 
LVL 1

Accepted Solution

by:
alx512 earned 0 total points
ID: 6289772
[modder]
0
 
LVL 2

Expert Comment

by:vanmeerendonk
ID: 6289797
[modder]
0
 
LVL 3

Expert Comment

by:modder
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.

modder
Community Support Moderator@Experts-Exchange
0

Featured Post

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

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

Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
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 recover a database from a user managed backup
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.
Suggested Courses

623 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