O'Reilly logo

Oracle GoldenGate 12c 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 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 ...

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