Re: Is there a way to conitionaly fire triggers ??

Are you in a position to put conditional logic inside the trigger to determine which type of delete you want? That way, the trigger would always fire but you would control its activity.

Perhaps a dummy column could be added to the table to be used as a flag?

HTH,
Michael

Matt Randle wrote:

> 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 - 17:57:10 CDT