Re: Database Trigger (URGENT!!!)

A copy of this was sent to Jvazquez <jvazqueNOjvSPAM_at_uacj.mx.invalid> (if that email address didn't require changing) On Thu, 30 Sep 1999 12:47:58 -0700, you wrote:

>I want to update a register when deleting a register from
>the same table becouse it has a recursive relation ...
>The table has the following fields:
>Code, Description, Qty, Child_Code (Where Child_Code is the
>recursive relation and Qty is the number of childs that the
>Code has).
> So, when deleting a record I would have to decrease the
>Qty field of the parent record.
> So far i have tried a AFTER_DELETE_ROW API trigger but an
>error like this one apears: "table SII.CGFONDOS_C is
>mutating, trigger/function may not see it", i can not
>obtain the Primary Key fields once they are deleted.
>
> Thank's much for your help...
>
>
>
>
>* Sent from RemarQ http://www.remarq.com The Internet's Discussion Network *
>The fastest and easiest way to search and participate in Usenet - Free!

See the web page in my URL. I have a HOWTO on avoiding mutating tables there.

-- 
See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'...
Current article is "Part I of V, Autonomous Transactions" updated June 21'st
 
Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation