8.4 Using EXIT_CALL_RESULT

Use EXIT_CALL_RESULT to provide a response to the routine.

Table 8-2 User Exit Responses

Call result Description

EXIT_ABEND_VAL

Instructs the caller to terminate immediately.

EXIT_IGNORE_VAL

Rejects records for further processing. EXIT_IGNORE_VAL is appropriate when the user exit performs all the required processing for a record and there is no need to output or replicate the data record.

EXIT_OK_VAL

If the routine does nothing to respond to an event, EXIT_OK_VAL is assumed. If the exit call type is any of the following...

  • EXIT_CALL_PROCESS_RECORD

  • EXIT_CALL_DISCARD_RECORD

  • EXIT_CALL_DISCARD_ASCII_RECORD

... and EXIT_OK_VAL is returned, then Oracle GoldenGate processes the record buffer that was returned by the user exit.

EXIT_PROCESSED_REC_VAL

Instructs Extract or Replicat to skip the record, but update the statistics that are printed to the report file for that table and for that operation type.

EXIT_STOP_VAL

Instructs the caller to stop processing gracefully. EXIT_STOP_VAL or EXIT_ABEND_VAL may be appropriate when an error condition occurs in the user exit.