Book Image

Oracle Goldengate 12c Implementers Guide

By : John P Jeffries
Book Image

Oracle Goldengate 12c Implementers Guide

By: John P Jeffries

Overview of this book

The book is aimed at Oracle database administrators, project managers, and solution architects who wish to extend their knowledge of GoldenGate. The reader is assumed to be familiar with Oracle databases. No knowledge of GoldenGate is required.
Table of Contents (16 chapters)
12
A. GGSCI Commands
13
B. GoldenGate Installed Components
14
C. Acronyms
15
Index

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:

Parameter

Description

EXIT_CALL_TYPE

This indicates when, during processing, the routine is called

EXIT_CALL_RESULT

This provides a response to the routine

EXIT_PARAMS

This supplies information to the routine

ERCALLBACK

This implements...