Extract abend when the Cols keyword selects a subset of columns and there are > 256 columns in the table

(Doc ID 1338900.1)

Last updated on JANUARY 13, 2017

Applies to:

Oracle GoldenGate - Version: 10.4.0.19 and later   [Release: 10.4.0 and later ]
Information in this document applies to any platform.

Symptoms


When  the COLS keyword is specified in extract to select a subset of columns and the number of columns in the table is > 256 you will see the following error.

2010-11-16 15:44:02 GGS ERROR 182 OCI Error binding select col 257 (ACCOUNT) (status = 1007-ORA-01007: variable not in select list), SQL<SELECT x."ORIGINATOR_OF_MESSAGE_ID",x."COUNTER_PARTY_ORG_ID",
x."INSTRUCTING_PARTY_ORG_ID",x."EXECUTING_BROKER_ORG_ID",
x."ALERT_COUNTRY_CODE",x."ALERT_METHOD_TYPE",
x."ALERT_SECURITY_TYPE",x."ALERT_SETT>.


Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms