My Oracle Support Banner

Reserved Words Used as Column Names (Aliases) Are Not Quoted by ODI 12.2.1.3 in Generated SQL (Doc ID 2541643.1)

Last updated on MAY 09, 2023

Applies to:

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

Symptoms

When Oracle Data Integrator (ODI) generates SQL code for Oracle Database 12.1.0.2.0, it is not surrounding some column attributes with quotes for certain reserved words, like "IN". Other keywords, like "CASE" are surrounded by quotes as expected.

It results in the following database error:

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.