Home » SQL & PL/SQL » SQL & PL/SQL » Error:table is mutating!
Error:table is mutating! [message #37122] Fri, 18 January 2002 23:13 Go to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 Go to previous message
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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 19 00:23:50 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.