Reserved Words Used as Column Names (Aliases) Are Not Quoted by ODI in Generated SQL
(Doc ID 2541643.1)
Last updated on OCTOBER 04, 2022
Applies to:
Oracle Data Integrator - Version 12.2.1.3.0 and laterInformation in this document applies to any platform.
Symptoms
When Oracle Data Integrator (ODI) 12.2.1.3.0 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:
ORA-01747: invalid user.table.column, table.column, or column specification
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! |
In this Document
Symptoms |
Changes |
Cause |
Solution |