My Oracle Support Banner

Joining Tables In GoldenGate Extract - ERROR OGG-00312 Closing Parenthesis Missing For WHERE. (Doc ID 2376401.1)

Last updated on MAY 11, 2022

Applies to:

Oracle GoldenGate - Version 11.2.1.0.4 to 12.3.0.1.3 [Release 11.2 to 12.3]
Information in this document applies to any platform.

Symptoms

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.

 

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


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