Re: Trigger question

You did probably get the "Mutating table" problem. We use a workaround for this problem.
In the ON EACH ROW trigger, we fill a PL/SQL table with the primary keys of each
row that is affected by the SQL statement. In the AFTER STATEMENT trigger, do the neccessary actions for each row that is in the PL/SQL table.

lgy_at_athylon.be or Luc.Gyselinnck_at_ping.be  Jim Finch wrote in article <335E9E96.497E_at_akron.infi.net>...
>I have a question about triggers in oracle. Here goes:
>
>Can you run a trigger that acts on table in a delete mode where the
>action of the trigger does a select on the same table where you are
>deleting a row?
>
>What I have is a Peoplesoft table that has a date field on it. I want to
>track when users delete rows but only if the row they delete is the most
>current.
>
>I've tried but with no sucess. It compiles but fails durring execution.
>
>
>Thanks in advance,
>
>
>Jim Finch
>jbfinch_at_akron.infi.net
>
Received on Thu Apr 24 1997 - 00:00:00 CDT