1. Microservices Architecture Documentation
  2. Administer
  3. Data Management
  4. Execute Commands, Stored Procedures, and Queries with SQLEXEC
  5. Handling SQLEXEC Errors
  6. Handling Database Errors

Handling Database Errors

Use the ERROR option in the SQLEXEC clause to direct Oracle GoldenGate to respond in one of the following ways:

Table 11-2 ERROR Options

Action Description 
IGNORE

Causes Oracle GoldenGate to ignore all errors associated with the stored procedure or query and continue processing. Any resulting parameter extraction results in a "column missing" condition. This is the default.

 
REPORT

Ensures that all errors associated with the stored procedure or query are reported to the discard file. The report is useful for tracing the cause of the error. It includes both an error description and the value of the parameters passed to and from the procedure or query. Oracle GoldenGate continues processing after reporting the error.

 
RAISE

Handles errors according to rules set by a REPERROR parameter specified in the Replicat parameter file. Oracle GoldenGate continues processing other stored procedures or queries associated with the current TABLE or MAP statement before processing the error. 

FINAL

Performs in a similar way to RAISE except that when an error associated with a procedure or query is encountered, any remaining stored procedures and queries are bypassed. Error processing is called immediately after the error. 

FATAL

Causes Oracle GoldenGate to abend immediately upon encountering an error associated with a procedure or query.