My Oracle Support Banner

ODI 12c Mapping Using <% in the Extract Options fails with "Missing end token: %>" Error (Doc ID 3073679.1)

Last updated on FEBRUARY 27, 2025

Applies to:

Oracle Data Integrator on Marketplace - Version 12.2.1.4.200123 and later
Oracle Data Integrator - Version 12.2.1.4.0 and later
Information in this document applies to any platform.

Symptoms

An Oracle Data Integrator (ODI) 12.2.1.4 Mapping has a CUSTOM_TEMPLATE implemented in the Mapping > Physical tab > source Datastore > Extract Options.

The SELECT command implemented in the above CUSTOM_TEMPLATE has a LIKE operator, such as, for example:

Note the same SELECT command succeeds if executed in SQLPlus or SQLDeveloper.
The issue therefore is specific to ODI.

Expected Behavior

Since the SQL command is correct, and successfully executes in SQLPlus and SQLDeveloper.

Steps to Reproduce

  1. Create a Mapping, and use the following SELECT command on the Physical tab > source Datastore > Extract Option > CUSTOM_TEMPLATE:

       select '<%' from dual

  2. Validate the Mapping, and observe there are no issues detected.

  3. Execute the Mapping in simulation mode, and observe the "Missing end token: %>... " error message received. No Session is started.

Changes

 

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.