Joining Tables In GoldenGate Extract - ERROR OGG-00312 Closing Parenthesis Missing For WHERE.
Last updated on APRIL 06, 2018
Applies to:Oracle GoldenGate - Version 184.108.40.206.4 to 220.127.116.11.3 [Release 11.2 to 12.3]
Information in this document applies to any platform.
Set up Extract to be selective on what records to capture from a table A using a WHERE clause querying table B, using in the parameter file something like:
table owner.A, KEYCOLS (DOC_ID, LINE_NUM) WHERE DOC_ID = owner.B.DOC_ID AND (owner.B.BILL_HEADER.CLIENT_ID=498 or owner.B.BILL_HEADER.CLIENT_ID=530);
Extract abends with:
2018-03-15 23:37:51 ERROR OGG-00312 Closing parenthesis missing for WHERE.
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