My Oracle Support Banner

ODI 12c Strings Containing Escaped Characters Result in "ORA-01425: escape character must be character string of length 1" Error (Doc ID 2435180.1)

Last updated on MAY 22, 2023

Applies to:

Oracle Data Integrator - Version 12.2.1.3.0 and later
Oracle Data Integrator Cloud Service - Version 17.2.1 and later
Oracle Data Integrator on Marketplace - Version 1.0.2 and later
Information in this document applies to any platform.

Symptoms

When executing a mapping in Oracle Data Integrator (ODI) 12c, the code is missing the backslash ('\'), tab ('\t') or other escaped characters. 

Please note, in the following examples there are placeholders which should be replaced by your actual values. These placeholders are in and include <>

Two examples of code in the User Function. 

 

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.