5.16 Session Variable Editor

Use to view the session variable details.

A session variable displays the values taken by a variable during the execution sessions.

The Session Variable Editor has the following tabs:

5.16.1 Definition

Properties Description
Name Name of the variable. It is prefixed by GLOBAL or the code of the project containing this variable.
Datatype Type of variable: Alphanumeric, Date, or Numeric.
Keep History Length of time the value of a variable is kept for:

  • No History: The value of the variable is kept in memory for a whole session.

  • Latest value: Oracle Data Integrator stores in its repository the latest value held by the variable.

  • All values: Oracle Data Integrator keeps the history of all the values held by this variable.
Secure Value Select Secure Value if you do not want the variable to be recorded. This is useful when the variable contains passwords or other sensitive data. If Secure Value is selected:

  • The variable is displayed as unresolved in the source or target code and is not tracked in the repository or historized.

  • The Keep History parameter is automatically set to No History and cannot be edited.
Default Value Default value assigned to the variable.
Description Detailed description of the variable.

5.16.2 History

This tab displays the history of the values of the variable.

Note that each value is attached to the context in which the session was executed:

  • Click Delete to remove a line from the history.

  • Click Context Filter field to filter the entries for a given context.

Related Topics

"Working with Variables" in the "Creating and Using Procedures, Variables, Sequences, and User Functions" chapter in Oracle Fusion Middleware Developing Integration Projects with Oracle Data Integrator