Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Table with trigger mutation
Everything works Ok except this trigger
>SVRMGR> create or replace trigger org_del3Received on Tue Dec 08 1998 - 03:49:31 CST
> 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