Controlling Trigger Firing

Control trigger firing through RS_TRIGGER_CONTROL package, which is automatically installed when a connection to the replicate Oracle database is created through connection profiles.

  1. Set the connection parameter dsi_keep_triggers to off so that Replication Server sets the RS_TRIGGERS_CONTROL enable flag when connecting to the replicate database.
  2. Add the trigger control PL/SQL code to the first line of your trigger action:
    if RS_TRIGGER_CONTROL.IS_ENABLED then    return;end if;	

    This indicates that a trigger is fired by Replication Server and prevents the trigger from executing the actual application logic.

    See the Replication Server Reference Manual.