The SQLEXEC parameter
Another powerful feature of GoldenGate is the SQLEXEC parameter. We will discuss when and how to use it as a standalone statement or in a TABLE or MAP statement to fulfill your data transformation requirements. SQLEXEC is valid for Extract and Replicat processes and can execute SQL statements or PL/SQL stored procedures.
Data lookups
On the target database, the SQLEXEC parameter in the MAP statement allows external calls to be made through a SQL interface that supports the execution of native SQL and PL/SQL stored procedures. This option is typically invoked to perform database lookups, thus obtaining data required to resolve a mapping and can only be executed by the GoldenGate (GGADMIN) database user.
Executing stored procedures ...
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.
