Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> delete record in update trigger possible

delete record in update trigger possible

From: Andre <avanrossem_at_hotmail.com>
Date: 9 Nov 2004 22:40:03 -0800
Message-ID: <4d32d1be.0411092240.28fc2300@posting.google.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?

Thanks and regards,
Anneke Received on Wed Nov 10 2004 - 00:40:03 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US