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: and later   [Release: 10.4.0 and later ]
Information in this document applies to any platform.


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",


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