My Oracle Support Banner

OGG Replicat ERROR OGG-00350 Error in SQLEXEC Clause When Using Multiple Input Params (Doc ID 2435214.1)

Last updated on JUNE 05, 2019

Applies to:

Oracle GoldenGate - Version 12.2.0.1.0 and later
Information in this document applies to any platform.

Symptoms

 Oracle GoldenGate Delivery for Oracle
Version 12.3.0.1.4 OGGCORE_12.3.0.1.0_PLATFORMS_180415.0359_FBO
Linux, x64, 64bit (optimized), Oracle 11g on Apr 15 2018 21:30:07

Replicat abends when SQLEXEC has more than one input PARAMS

Snippet of the parameter
map ggs.tcustord, target hr.tcustord, SQLEXEC (ID detect_conflict, ON INSERT,
...
params (a_custcode=cust_code,a_product=product_code)

2018-07-05 03:20:39 ERROR OGG-00350 Error in SQLEXEC clause, id
detect_conflict: Invalid parameter name: a_product.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.