Oracle GoldenGate BigData String Substitution Of ASCII NULL - " Value zero (0) (\x00 and \000) is not allowed because it is a string terminator." (Doc ID 2990247.1)

Last updated on JULY 20, 2024

Applies to:

Goal

Running OGG integrated extracts from Oracle DB and subsequent replicats of OGG BigData filewriter handler process producing text outputs from extracted trail files.
We perform several substitutions of extracted data (LF linefeed and CR carriage return chacharters are replaced with empty string) using @STRSUB function in replicat param file,Source database data contain also numerous NULL (ASCII 0) characters. When extracted and written to output text files it results in truncation of extracted string. We want to substitute this character as well - however, @STRSUB function is not working for this specific character. Oracle OGG reference manual states, under @STRSUB function: " Value zero (0) (\x00 and \000) is not allowed because it is a string terminator." Can you advice if there is any other way how to perform this conversion/substitution? If NULL/x00/000 is not allowed as an argument in STRSUB function, we are not able to correctly extract/replicate all database content, making our replication solution unusable .
 

Solution

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