troubleshooting Question

ORA-04091 mutating table problem in Before trigger.

Avatar of sblang
sblang asked on
Oracle Database
6 Comments2 Solutions10211 ViewsLast Modified:
I had read in reply to a similar question that the way around the mutating table problem was to create a before trigger to collect the data needed in global package variable.

I followed this advice but I am still getting the ora-04091 error.

I created before trigger that calls a function in a package that also contains a public pl/sql table to store the information I need in the after trigger. The function contains a cursor that includes a reference to the trigger table.

Am I correct in assuming that I cannot query the table being updated period! (i.e. in either the before or after trigger)!
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 2 Answers and 6 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 6 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros