| ORACLE TRIGGERS [message #369837] |
Thu, 19 October 2000 14:12  |
Don Thaler
Messages: 8
Registered: October 2000
|
Junior Member |
|
|
|
I'm trying to create an after insert trigger that will update the table that the trigger is firing on and of course if i use the 'update' statment i get an ora-04091 error(can't modify a table in the middle of being modified by the statement that fired the trigger). I tried to use :newdata variable and got an error in the compile that this variable couldn't be used in this type of trigger. I finally changed the trigger to a 'before insert' and got it to work with the :newdata variable. Does anyone have any suggestions about getting the 'after insert' trigger to work?
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
