"unexpected token: LEFT" Generating ANSI Query with XML Source in ODI
(Doc ID 2686373.1)
Last updated on MARCH 20, 2023
Applies to:
Oracle Data Integrator - Version 12.2.1.0.0 and laterOracle Data Integrator on Marketplace - Version 12.2.1.4.200123 and later
Information in this document applies to any platform.
Symptoms
When using Oracle Data Integrator (ODI) to load the contents of an XML File to a database, the wrong SQL code is generated whenever a LEFT JOIN clause is used. It causes the following error upon execution:
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! |