Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: delete record in update trigger possible
Andre wrote:
> 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?
>
> Thanks and regards,
> Anneke
Try it.
-- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace 'x' with 'u' to respond)Received on Thu Nov 11 2004 - 22:32:42 CST