My Oracle Support Banner

ODI REGEXP_REPLACE Functions in OdiSqlUnload Return Incorrect Result Data (Doc ID 2891885.1)

Last updated on AUGUST 07, 2024

Applies to:

Oracle Data Integrator on Marketplace - Version 12.2.1.4.220426 to 12.2.1.4.220702
Oracle Data Integrator - Version 12.2.1.4.220426 to 12.2.1.4.220702 [Release 12c]
Information in this document applies to any platform.

Symptoms

In an Oracle Data Integrator (ODI) mapping which uses OdiSqlUnload where an sql query uses a REGEXP_REPLACE function like the following, the data returned is incorrect.


Incorrect Data Format:

2015-01-01|\3.\2.\1
2000-12-31|\3.\2.\1
900-01-01|\3.\2.\1

 

Expected and Correct Data Format:

STRING|MODIFIED_STRING
---------- ------------------------
2015-01-01|01.01.2015
2000-12-31|31.12.2000
900-01-01|01.01.900



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!

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