trigger to act on itself [message #254] |
Fri, 01 February 2002 03:53 |
Anthony
Messages: 48 Registered: September 2000
|
Member |
|
|
I am trying to create a trigger that is called after a record has been inserted into a table.
I would like the trigger to insert another record into the same table but with some hard-coded variation on one of the fields.
I get the message Ora-04091 something about a mutating table or something. Is it possible to have a trigger that inserts into itself another record after having one inserted?
|
|
|
Re: trigger to act on itself [message #275 is a reply to message #254] |
Sat, 02 February 2002 12:18 |
Suresh Vemulapalli
Messages: 624 Registered: August 2000
|
Senior Member |
|
|
operation on triggering table is not allowed from row level trigger. store all inserted values into packaged pl/sql table and insert those records into table from after insert statement level trigger.
|
|
|