Last updated on FEBRUARY 08, 2017
Applies to:Oracle Data Integrator - Version 126.96.36.199.0 and later
Information in this document applies to any platform.
After having upgraded from Oracle Data Integrator (ODI) 10g to 11g, ODI Variable refresh statements which return a string with DATE content does not have the same content as in the previous version.
More specifically, in ODI 10g, the following SQL instruction:
returns values in the format:
However, in ODI 11g, the returned values are in the format:
This means that we will be obliged to manually modify all the related Variables.
Why is this occurring and is there a workaround?
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms