My Oracle Support Banner

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 12.3.0.1.2 and later
Information in this document applies to any platform.

Symptoms

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.

syntax:

@STREXT (string, begin_position, end_position)
string

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.

begin_position

The byte position at which to begin extracting.

end_position

The byte position at which to end extracting. The end position is included in the extraction.

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
References


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