Re: Error ORA-04091

Have you mentioned your pragma?
"pragma restrict_references (yourprocedure, WNDS, WNPS, RNPS,RNDS)"

In this statement you can say what sort of action you want to do with your SP.
The last 4 parameters are optional and you can specify some of them. Look at the server manual and search for "pragma" or "restrict_references".

PH

Luca Cappelletti <NOSPAM_cappelletti_at_programmers.net> wrote in message news:37c03535.911720_at_proxy...
> Hi!
> Is there anybody who knows this error?
> I'm calling a stored procedure from an "AFTER INSERT" trigger. The SP
> open a cursor and modifies a lot of records of the same table invoking
> the trigger.
>
> The error code and decription are: "ORA-04091: table MYSCHEMA.MYTABLE
> is mutating, trigger/function may not see it"
>
> Help me!
> Thanks in advance.
> Luca
Received on Wed Aug 18 1999 - 19:49:29 CDT