WHEN clause in triggers

The Replication Agent table-marking script creates (or alters existing) triggers on a table. In the case of existing triggers, the script inserts Replication Agent code at the end of the trigger, so that any existing trigger operations take place first.

If a trigger contains a WHEN clause that could cause an early exit from the trigger, this jeopardizes the reliability of the Replication Agent trigger code.

NoteSybase recommends that you do not use a WHEN clause that can cause an early exit from the trigger on Oracle tables you mark for replication.