Re: How Can I do This

Manoj.V.S. <mbws_at_batelco.com.bh> wrote in article <3272BEC0.489F_at_batelco.com.bh>...
> Hello

 ... Snip
> ERROR: ORA-04091:table GL.ACCODE is mutating, trigger/function may not
> see it
>
 ... Snip
> CREATE OR REPLACE TRIGGER Trig_AcCode_AI
> AFTER INSERT ON AcCode
> FOR EACH ROW
> DECLARE
> CURSOR CurPeriod IS SELECT yno,pno FROM Period;
> BEGIN
> FOR x IN CurPeriod LOOP
> INSERT INTO PERBAL (accode,dep,yno,pno)
> VALUES (:NEW.accode,:NEW.dep,x.Yno,x.Pno);
> END LOOP;
> END;
>

Try doing this as a BEFORE INSERT trigger Received on Mon Oct 28 1996 - 00:00:00 CET