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
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.
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.