Oracle GoldenGate: Run SQLEXEC within MAP clause only once, accessing @GETENV parameters

As of version of Oracle GoldenGate there is a restriction for standalone SQLEXEC statements, such statements can’t access parameters normally accessed with @GETENV function. To bypass this restriction we should make SQLEXEC within MAP clause to run only once per every replicat invocation. This can be achieved using global temporary table as target and […]