Re: Mutating problem

Hi,

manoj67_at_hotmail.com wrote:
>
> Hi Philippe,
>
> Mutaing Error Problem:-
>
> 1. You only get mutating errors from per-row triggers, not from after
> statement or before statement triggers (unless they are under per-row
> triggers).
> 2. You only get these when you modify a table being read or you read a
> table being modified.
>
> The (unfortunate) solution is to have per-row triggers write what they see
> into a side table. The side table can be a PL/SQL table or an actual table
> on disk. Then the after statement trigger reads that data, does the changes

There's another solution - use stored procs to modify/read mutating table.
I checked it on Oracle 7.3.3 - it works. What does interest me, is it a 'legal' way... What would Oracle say? :)

Thanks,
Igor

--
Igor Sereda,
ITC, Russia Received on Wed Apr 22 1998 - 13:46:49 CDT