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.
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.
The following example maps data from the