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:
-
Connect to Replicat in the target database.
REPLICAT rdbaUSERIDALIAS admin_dbBDOMAIN ORADEV -
Include filter for procedure replication.
PROCEDURE EXCLUDE FEATURE RLS -
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.