Is there a way to conitionaly fire triggers ??

From: Matt Randle <matt_at_imat.demon.co.uk>
Date: Thu, 13 May 1999 22:21:30 +0100
Message-ID: <926630827.21277.0.nnrp-08.d4e48d0d@news.demon.co.uk>

Hello,

I have a slight problem with Oracle triggers.

A requirement of the system we are building is that you can delete data either semi-permanently (it gets copied to an exact mirror of the actual tables) or permanently (it is removed without trace).

The easiest way to do the semi-permanent delete is to use On Delete triggers to copy deleted data to the deleted tables. However, if I do this how do I allow for permanent delete - ie. is there anyway of stopping the trigger from firing and copying the deleted data ??

Matt. Received on Thu May 13 1999 - 16:21:30 CDT