"-PASS" Parameter Of OdiSqlUnload Command Is Removed When Exporting In ODI 12.1.3 A Scenario That Contains That Command

(Doc ID 2249917.1)

Last updated on APRIL 04, 2017

Applies to:

Oracle Data Integrator - Version 12.1.3.0.0 to 12.1.3.0.0 [Release 12c]
Information in this document applies to any platform.

Symptoms

Having a Package in Oracle Data Integrator (ODI) 12.1.3.0.0 that implements an OdiSqlUnload command, where the -PASS parameter is set to use an ODI Variable.

When exporting a Scenario from above Package, without cipher text, the -PASS parameter is removed in the export file.

Note the same works well in ODI 12.1.2 and 12.2.x

Cause

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 hundreds of Community platforms