How To Dynamically Set/Unset Session NLS Parameters When Connecting/Disconnection To/From ODI Data Servers
Last updated on FEBRUARY 08, 2017
Applies to:Oracle Data Integrator - Version 188.8.131.52.0 and later
Information in this document applies to any platform.
It is now possible in ODI 184.108.40.206.0 and forward to define ODI Data Server SQL commands which will be automatically executed when a connection to a Data Server defined in the Physical Architecture is created or closed.
Such a command can be used for altering and pre-configuring sessions (for example, for internationalization of messages or forcing implicit conversions) or in multi-tenant infrastructure where commands must be placed at connection time to access information of a given tenant.
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