Re: Table with trigger mutation

From: Andrey A. Kulaga <kulaga_at_zenon.net>
Date: 07 Dec 1998 17:56:04 +0300
Message-ID: <7ou2z8xapn.fsf@sor.zenon.net>

"Valentine Pogrebinsky" <pva_at_azovimpex.donetsk.ua> writes:

>
> This trigger raise exception "ORA-04091 Table ORG is mutaiting,
> trigger/function may not see it." But I really need this way modification of
> both tables
>
> Thanks for any help.
>
> Valentine Pogrebinsky

You can create two triggers - table level and row level. Row level trigger record Org_ID into PL/SQL table inside some package, whereas table level will delete rows from Obj table using records in PL/SQL table. Received on Mon Dec 07 1998 - 08:56:04 CST