Table triggers

Posted by arainxius on 28-Feb-2008 09:40

What exactly are the differences between the table triggers "WRITE" trigger and "REPLICATION-WRITE" trigger ??

All Replies

Posted by jtownsen on 03-Mar-2008 03:40

Usually WRITE triggers are used by the "owner" of the application if write triggers are necessary. REPLICATION-* triggers are then left available for non-application owners to do something when the particular event occurs.

A typical example is when someone buys an application without the source code, but wants to hook into these events. Without the REPLICATION-* triggers, the TRIGGER source code would need to be changed.

You should be very careful to not change the application behaviour in the REPLICATION-* triggers (ie. no RETURN NO-APPLY or unhandled errors).

This thread is closed