Question Related To OGG-01298 COLUMN FUNCTION DIAGNOSTIC MESSAGE (EXTRACT QUOTATION MARKS PROBLEM)

(Doc ID 2376650.1)

Last updated on APRIL 15, 2018

Applies to:

Oracle GoldenGate - Version 12.3.0.1.2 and later
Information in this document applies to any platform.

Goal

I am migrating from oracle golden gate version 11.2.1.0.6 to 12.3.0.1.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
 

Solution

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