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

Handling SQLEXEC Errors

There are two types of error conditions to consider when implementing SQLEXEC:

  • The column map requires a column that is missing from the source database operation. This can occur for an update operation if the database only logs the values of columns that changed, rather than all of the column values. By default, when a required column is missing, or when an Oracle GoldenGate column-conversion function results in a "column missing" condition, the stored procedure does not execute. Subsequent attempts to extract an output parameter from the stored procedure results in a "column missing condition" in the COLMAP or FILTER clause.

  • The database generates an error.