Configuring a stored procedure as a table-level user exit

You can configure a stored procedure as a table-level user exit.

Procedure

  1. Click Configuration > Subscriptions.
  2. Select the subscription.
  3. Select the table mapping in the Table Mappings view.
  4. Right-click and select Open Details....
  5. Click the User Exits tab.
  6. Select Stored Procedure from the User Exit Type list.
  7. Enter the name of the schema that contains the stored procedure in the Schema box.
  8. Enter the name of the user exit programs you want CDC Replication to call beside one or more of the following operations:
    Before Insert
    CDC Replication runs the user exit before replicating an insert operation.
    After Insert
    CDC Replication runs the user exit after replicating an insert operation.
    Before Update
    CDC Replication runs the user exit before replicating an update operation.
    After Update
    CDC Replication runs the user exit after replicating an update operation.
    Before Delete
    CDC Replication runs the user exit before replicating a delete operation.
    After Delete
    CDC Replication runs the user exit after replicating a delete operation.
    Before Refresh
    CDC Replication runs the user exit before replicating a refresh operation.
    After Refresh
    CDC Replication runs the user exit after replicating a refresh operation.
    Before Truncate
    CDC Replication runs the user exit before replicating a truncate operation.
    After Truncate
    CDC Replication runs the exist after replicating a truncate operation.
  9. Click Save.