OGG 12.3 STREXT("string", 1, 1) Returns NULL Instead of Returning Single Character
(Doc ID 2422210.1)
Last updated on FEBRUARY 27, 2019
Applies to:Oracle GoldenGate - Version 188.8.131.52.2 and later
Information in this document applies to any platform.
The usage of OGG function - Strext - to extract a portion of a string, works fine for multiple characters (<column_name>,1,3) but does not work for single character (<column_name>,1,1) when used in colmap.
@STREXT (string, begin_position, end_position)
The string from which to extract. The string can be either the name of a character column or a literal string. Enclose literals within single quote marks.
The byte position at which to begin extracting.
The byte position at which to end extracting. The end position is included in the extraction.
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