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 22.214.171.124.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.
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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!