Re: Mutating Triggers in Oracle

Marcelo Vinagreiro wrote:
>
> Hi,
>
> I've needed to implement a mutating trigger in Oracle.
>
> Thus, I followed the 3 default steps:
>
> 1. I created a package structure which keeps a temporary table;
>
> 2. One row trigger that populates the temporary table that was
> implemented. This one has the "for each row..." statement.
>
> 3. And I created a statement trigger which has the logic I need. So,
> it is possible to perform selects in the same table which has been
> triggered.
>
> All works fine, but I realized a problem: the temporary
> table generated by my package doesn't seem to be cleaned... So, there
> were repetitions... Is there any way to clean the package after an
> execution of the statement trigger (described in 3) ?
>
> Best regards!
>
> Marcelo

You need a before-statement trigger which empties the temorary or plsql table

hth
connor

-- 
=========================
Connor McDonald
http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue"