User exits

If you find that your application requires arithmetic calculation or data transformation beyond what is provided by GoldenGate functions and SQLEXEC, it is possible to invoke user exits. These are user-defined C or C++ function calls, extending the capabilities of GoldenGate. Typical applications for user exits are housekeeping tasks, data normalization, and conflict detection and handling.

Calling C routines

The user-defined functions may be called from either an Extract or Replicat process via the CUSEREXIT parameter.

To use user exits, create a shared object in C and create a routine to be called from Extract or Replicat.

The routine must accept the following parameters that provide the communication between GoldenGate and your C program: ...

Get Oracle GoldenGate 12c Implementer's Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.