Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Table with trigger mutation
Hi,
I am sorry, it was my mistake.
Andrew Protasov
> 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 - 08:13:58 CST