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 |