Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: problem with trigger
Nope. You will get trigger mutating error if you are doing row level trigger.
You will need to create a temporary table and a new statement after trigger.
Hope this help.
Alan
In article <76uk9i$eev$1_at_nnrp1.dejanews.com>,
arunal_at_hotmail.com wrote:
> hi all,
> I have created a trigger on a table t1 for update of some of the fields in
> the table t1. In the same trigger is it possible for me to insert records into
> the same table t1.
> Thanks in advance
> aruna
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>
-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Jan 06 1999 - 11:08:10 CST