RE: "ORA-04091" Mutating Error

SSC Guru

Points: 323506

April 16, 2013 at 5:17 am

it's been a long time since you followed up on this, and you've changed which tables you are referring to.

did you fix the issue on MODEL_CODE and now have the same mutating issue on another suite of tables?

can you show us the DDL of both the STUD table, and the trigger you created to try and update the LIB table?

there's lots and lots of examples you could modify if you are stuck on syntax, so you've got to provide a lot more detail if you want help from a forum.

Search q=oracle+trigger+update+another+table

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!