How To Call Multiple Commands in ODI for Oracle Data Server "On Connect/Disconnect" Events
(Doc ID 2655922.1)
Last updated on SEPTEMBER 12, 2023
Applies to:
Oracle Data Integrator - Version 12.2.1.3.0 and laterOracle Data Integrator on Marketplace - Version 12.2.1.4.200123 and later
Information in this document applies to any platform.
Goal
During an Oracle Data Integrator (ODI) 12c session execution, it is required to initiate more than one command during On Connection or On Disconnect events for an Oracle Database data server.
For example, both of the following commands must be executed whenever an ODI connection is made with a particular Oracle data server.
- ALTER SESSION SET NLS_LENGTH_SEMANTICS ='CHAR'
- ALTER SESSION SET CURSOR_SHARING = FORCE
What is the correct way to execute several commands?
Solution
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |