My Oracle Support Banner

ODI Variable Refresh Query That Incorporates a Reserved Word in the Select Query Returns a Different Result in ODI 10g Compared to ODI 11g when Schema is Sunopsis Memory Engine (Doc ID 1550678.1)

Last updated on OCTOBER 13, 2023

Applies to:

Oracle Data Integrator - Version to [Release 11gR1]
Information in this document applies to any platform.


A Refresh Variable has been defined that incorporates a reserved word in the SQL SELECT query.

When this SELECT is executed in Oracle Data integrator (ODI) 10g compared to ODI 11g, the results differ.

Test case steps

  1. Create the table in HSQL database (which is used by the ODI Memory Engine technology):

  2. Insert into the table values retrieved from "Command on Source":

  3. Now refresh a Variable where the query retrieves the results from the table insert:

The results will differ in ODI 10g compared to ODI 11g:


 Environment upgraded from ODI 10g to ODI 11g.


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.