Question Related To OGG-01298 COLUMN FUNCTION DIAGNOSTIC MESSAGE (EXTRACT QUOTATION MARKS PROBLEM)
Last updated on APRIL 15, 2018
Applies to:Oracle GoldenGate - Version 126.96.36.199.2 and later
Information in this document applies to any platform.
I am migrating from oracle golden gate version 188.8.131.52.6 to 184.108.40.206.2 and from database enterprise edition 11gr1 to 12cr2 and from windows XP service pack2 to windows 2016 server
Problem is with process and replicat processes, the behavour of the " to call table columns has changed. As instance in extract process when filtering:
table affl, filter (@strfind (cat_code, "aflgeo") = 0); --> in 11g
table affl, filter (@strfind (cat_code, 'aflgeo') = 0); --> in 12c ( I had to change " to ' in order to run the process, if not OGG-01298 appears)
I opened a service requests previously and they told me to write ' to solve the issue. Anyway, I haven't read that in the new release of golden gate there is such change.
Might it be related to a parameter of the database or the OS?
I would like to have if possible same version of my parameter files (in 11g and 12c) to run in both environments
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