O'Reilly logo

Oracle GoldenGate 11g Implementer's guide by John P Jeffries

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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.

Data lookups

On the target database, the SQLEXEC parameter in a MAP statement allows external calls to be made through an SQL interface that support s the execution of native SQL and PL/SQL stored procedures. This option is typically invoked to perform database lookups to obtain data required to resolve a mapping and can only be executed by the GoldenGate (GGS_ADMIN) database user.

Executing stored procedures

The following example maps data from the CREDITCARD_ACCOUNT ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required