Re: delete record in update trigger possible

Am 9 Nov 2004 22:40:03 -0800 schrieb Andre <avanrossem_at_hotmail.com>:

> Hello all,
>
> I have a simple (?) question.
> In an update trigger I want to delete a record.
>
> For example:
> If :new.correctprocessed = 1 then
> delete this record;
> end if;
>
> Is this possible or do I have to do it another way?

This is not possible, because the trigger table is "mutating" and therefore the trigger may not "see" it.
Seems to me an odd behaviour, if the database deletes records which an application tries to update.

-- 
Frank Piron,
etfrankatkonaddotn
(leftrotate two)