Re: MUTATING PROBLEM !!! IN DATABASE TRIGGER

> > I definided a Before delete trigger that performs:
> >
> > DECLARE
> > NO_DELETE exception;
> > Begin
> > raise NO_DELETE;
> > EXCEPTION
> > when NO_DELETE then
> > UPDATE T set HIDDEN_DATE = SYSDATE where rowid = :old.rowid;
> > End;
> >
> > But I receive an ORA-04091: table T is mutating, trigger/function may
> > not see it.
> > > Do you know another possible solution ?
> >

Rather than try and stop the delete, why not let the delete go through, but use the trigger to insert a copy of the deleted record back into the table. for example:

insert into T (colname, colname, colname, hidden_date, ...) values (:old.colname, :old.colname, :old.colname, SYSDATE, ...) etc

I havent tried it, bit it should work as it avoids a direct select or update on the source (mutating) table.

TC

.
.
.
.
.
.