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: Table with trigger mutation

Re: Table with trigger mutation

From: Valentine Pogrebinsky <pva_at_azovimpex.donetsk.ua>
Date: Tue, 8 Dec 1998 11:49:31 +0200
Message-ID: <74isnv$ih3$1@hyppo.anet.donetsk.ua>


Everything works Ok except this trigger

>SVRMGR> create or replace trigger org_del3

> 2> after delete on org
> 3> begin
> 4> for i in 1..id_table.org_id_table.count loop
> 5> delete from obj where id=i;
> 6> end loop;
> 7> end;
> 8> /
Line 5 must be
> 5> delete from obj where id=id_table.org_id_table(i);
Thank you for your help Valentine
Received on Tue Dec 08 1998 - 03:49:31 CST

Original text of this message

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