OraFAQ Forum: SQL & PL/SQL » Error:table is mutating!

Home » SQL & PL/SQL » SQL & PL/SQL » Error:table is mutating!

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

Error:table is mutating! [message #37122]

Fri, 18 January 2002 23:13

Anatol
Messages: 15
Registered: January 2002

Junior Member

Hello!
I want to make when a user insert some dates in table some columns are insert by trigger and cannot to make because of error that the table is mutating .

Report message to a moderator

Re: Error:table is mutating! [message #37125 is a reply to message #37122]

Sat, 19 January 2002 08:18

Suresh Vemulapalli
Messages: 624
Registered: August 2000

Senior Member

store those values which you want to insert(via trigger) in packaged pl/sql table and insert those values in after insert statement level trigger.

Report message to a moderator

Re: Error:table is mutating! [message #37156 is a reply to message #37122]

Mon, 21 January 2002 18:41

Satish Shrikhande
Messages: 167
Registered: October 2001

Senior Member

It's a drawback of a trigger ,
we can't refere a table on which we are creating trigger .

Report message to a moderator

Re: Error:table is mutating! [message #37161 is a reply to message #37122]

Mon, 21 January 2002 20:35

dinakar shetty
Messages: 29
Registered: January 2002

Junior Member

Hi
If u want to insert some values in to the same row columns then use :new.column name

If u want to insert a new row
then u have to follow what suresh told
or
u can u DBMS_JOBS

Report message to a moderator

Re: Error:table is mutating! [message #37167 is a reply to message #37122]

Tue, 22 January 2002 00:16

Milind S Deobhankar
Messages: 33
Registered: January 2002

Member

The trigger on the table is trying to update or insert or delete th rows which are just happened from your DML statement.

Report message to a moderator

Previous Topic:	Using create ... in trigger
Next Topic:	Alais tables

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue May 05 05:43:05 CDT 2026