Handling Procedural Replication Errors

Procedural replication uses REPERROR parameter to configure the behavior of Replicat when an procedural error occurs.

By default, Replicat will abend when a procedural replication occurs so using the following steps sets up error handling:

  1. Connect to Replicat in the target database.

    REPLICAT rdba

    USERIDALIAS admin_dbBDOMAIN ORADEV

  2. Include filter for procedure replication.

    PROCEDURE EXCLUDE FEATURE RLS

  3. Specify error handling parameter, see REPERROR in Reference for Oracle GoldenGate for other options.

    REPERROR (PROCEDURE, DISCARD)

You have successfully handled errors for procedural replication.