Re: trigger?

<snipped>

> I want the trigger on the same table that I want the deletes to occur.
> Anyway, here's what I've come up with. I hope it's at least close.
>
> create or replace trigger trigger_name1
> after update on tableA
> for each row /* I don't think I need this */
> begin
> delete from table_a
> where
> date_field <= sysdate - 3;
> end;
>
> Thanks for you comments.
> tony

This can not be done. If you have not seen the word "mutating" before you will quickly learn that it and its associated error messages preclude any trigger such as the one you describe.

Daniel A. Morgan Received on Sat May 19 2001 - 02:47:32 CDT