OraFAQ Forum: SQL & PL/SQL » URGENT - ORA-04091 table name is mutating, trigger/function may not see it

Home » SQL & PL/SQL » SQL & PL/SQL » URGENT - ORA-04091 table name is mutating, trigger/function may not see it

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

URGENT - ORA-04091 table name is mutating, trigger/function may not see it [message #2170]

Tue, 25 June 2002 22:46

Kjell
Messages: 7
Registered: February 2002

Junior Member

Hi I'm getting the following error message

ORA-04091 table name is mutating, trigger/function may not see it

The cause is: A trigger or a user-defined PL/SQL function that is referenced in the statement attempted to query or modify a table that was in the middle of being modified by the statement that fired the trigger.
Action: Rewrite the trigger or function so it does not read the table.

Question: I want to read the table (in a procedure that is called by the trigger) How can I do this without getting an error??

All the best
Kjell-Ivar

Report message to a moderator

Re: URGENT - ORA-04091 table name is mutating, trigger/function may not see it [message #2228 is a reply to message #2170]

Sun, 30 June 2002 22:57

Saga
Messages: 51
Registered: April 2002

Member

Mutating trigger problem can be resolved with the use of
1. autonomous transaction or
2. 1 package and 2 triggers

For detail solution give more details of your problem

Report message to a moderator

Previous Topic:	sql query...
Next Topic:	how can I get the full date data?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 24 20:56:13 CDT 2024