On Tue, 16 Dec 2003 16:42:03 +0000 (UTC), Martin Dew wrote:

> ...
> When I have a problem with a trigger and think it is not firing I tend
> to write an exception into the database, and start adding exception
> lines in the trigger, that way if the exception fires at one part but
> not in another then you are not reaching that desired point in the
> trigger. So it could actually be your if statement that is not working
> the exact way you want it too..

Another method is to insert records into an external table.

--
Aage J.