Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: problem with trigger

Re: problem with trigger

From: <tienlee_at_mailexcite.com>
Date: Wed, 06 Jan 1999 17:08:10 GMT
Message-ID: <77059n$pcu$1@nnrp1.dejanews.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US