1. Oracle GoldenGate Classic Architecture Documentation
  2. Administer
  3. Data Management
  4. Oracle: DDL Replication
  5. Configuring DDL Support
  6. Using Tools that Support Trigger-Based DDL Capture
  7. Handling DDL Trigger Errors

Handling DDL Trigger Errors

Use the params.sql non-executable script to handle failures of the Oracle GoldenGate DDL trigger in relation to whether the source DDL fails or succeeds. The params.sql script is in the root Oracle GoldenGate directory. The parameters to use are the following:

  • ddl_fire_error_in_trigger: If set to TRUE, failures of the Oracle GoldenGate DDL trigger are raised with a Oracle GoldenGate error message and a database error message to the source end-user application. The source operations fails.

    If set to FALSE, no errors are raised, and a message is written to the trigger trace file in the Oracle GoldenGate directory. The source operation succeeds, but no DDL is replicated. The target application will eventually fail if subsequent data changes do not match the old target object structure. The default is FALSE.

  • ddl_cause_error: If set to TRUE, tests the error response of the trigger by deliberately causing an error. To generate the error, Oracle GoldenGate attempts to SELECT zero rows without exception handling. Revert this flag to the default of FALSE after testing is done.