How to prevent table entry from being deleted but perform statements in the body of a trigger ?
Date: 9 Jul 2003 01:41:23 -0700
Message-ID: <1b37c0d4.0307090041.4921b2a2_at_posting.google.com>
Hi everybody!
My problem is as following:
I have a trigger which fires on delete of a table row. The body of the
trigger checks and manipulates entries in other tables.
If the entries have certain values, I would like the row of the table
which has fired the trigger not to be deleted. As far as I understood
this problem could be solved by a user defined exemption. But when
using an exemption all the manipulations in the other tables are
rolled back as well which I don't want them to do. Furthermore the
trigger should then write a row into the table "ERRORS" which contains
information about the kind of the error and the time it occured.
Does anybody have an idea how to solve this problem?
Thanks Robert