My Oracle Support Banner

Frequently Asked Questions Concerning ODI Variables (Doc ID 471564.1)

Last updated on OCTOBER 19, 2023

Applies to:

Oracle Data Integrator - Version 3.2.03.01 and later
Oracle Data Integrator on Marketplace - Version 12.2.1.4.200123 and later
Information in this document applies to any platform.
The article applies to all releases of ODI like the current 12C as well as to previous releases.


Purpose

Document includes all questions and problems on Oracle Data Integrator (ODI) Variables that have been asked.

Note these are specific technical questions only and are used to document solutions to frequent customer questions as well as any known problems.

For more information read the ODI Documentation User's Guide and Reference Guide on ODI Variables.

 

Questions and Answers

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Questions and Answers
 Troubleshooting
 Known issues
 1. Declare Text Type Variable Does not Return its Default Value
 2. 'OutOfMemoryError' Message When Consulting Historical Data Of An  ODI Variable
 3. SNP_VAR_DATA And "numeric overflow" Message
 4. When Trying To Rename An ODI Variable, Designer Freezes While CPU Usage Saturates at 100%
 5. Incorrect Variable References In ODI Expression Editor
 6. Error "java.lang.NumberFormatException: For input string: "null"" Signaled When Executing A Scenario In ODI Metadata Navigator While Passing In A Value to Variables
 7. 'String or binary data will be truncated' Error When Executing an Object
 8. Passing ODI Variables As Parameters Results In Incorrect Substitution By The Parsing Phases.
 9. Comparing A Numeric ODI Variable With An Integer
 10. "Object does not exist in the database" Message Signaled When Refreshing Variables
 11.  Unable To Assign A Variable Value In ODI When Its Value Contains Double-Quotes
 Problems from Setup/Environment/Usage
 1. "Command is not a valid loading command" Message When Using The Bind Mechanism With ODI Specific Procedures.
 2. "An object will be in an unidentified state...." Message Is Randomly Displayed
 3. "String index out of range" on execution of a Procedure or Command
 4. ODI Variables And java.lang.Exception: Unresolved variable Errors
 5. After Modifying ODI Integration Interfaces Table Prefixes Then The Loading is Problematic
 6. Refresh Of An ODI Variable Based On A SQL Request To A Temporary Informix Table
 7. "NumberFormatException" Error When Comparing ODI Variable values
 8. How To Refresh An ODI Variable With A MOM
 9. What Is The Impact Of Daylight Saving Time (Summer Time) On ODI Variables?
 Best Practices
 1. Recommendations For Working With ODI Variables
 2. Is It Possible To Create ODI Variables With Short names Without Appending The Project Or GLOBAL Scope Information To It?
 3. Best practices for Project type ODI Variables Import Modes
 4. What Is The Distinction Between '#' and ':' Calls To ODI Variables?
 5. Collisions between ODI Bind Tags (":") and SQL Statements
 6. Is It Necessary To Regenerate A Scenario After Modifying The Refresh Statement Of An ODI Variable?
 7. Recommendations For ODI Variables To Store Date Values
 8. In a Package, when setting a step of Variable type, ODI defaults to "Set Variable" Step type. This means that a news value will be affected to the Variable, but ODI does not propose any, leaving it to blank.
  Conditional Programming In The Package Using The Variable
 1. Setting Up Conditional Execution In ODI Packages Depending On A Table column value
 2.  Using an ODI Variable As A Flag To Determine Whether A Session Of The Same Scenario Is Already Running?
 3. How To Conditionally Replace Data In A Target Datastore?
 Typical Used-In Cases
 1. Using ODI Variables To Generate Unique Temporary Table Names During Package Run Time.
 2. Using ODI Variables To Generate Unique XML Schema Name During Package Run Time
 3. Using ODI Variables To Generate Unique URL of a Data Server During Package Run Time
 4. Using ODI Variables to dynamically specify Table Column names
 5. How Can I Dynamically Set An Integration Interface Source Set Name At Run Time?
 6. Using A Dynamically Specified File Name Or Directory Name
 7. Creating And Populating ODI Datastores With Multiple Variable Name
 8. How Can I Dynamically Export Scenarios Attached To A Project?
 9. The Use of ODI Variables To Set Values To Procedure Or Knowledge Module
 10. Retrieving The Name Of The Current ODI Work Repository At Run Time
 11. Using ODI Variables To Capture Runtime Error Messages
 Usage with Other Tools
 1. May ODI Variables Be Used In Substitution Methods Such As 'getObjectName' ?
 2. Collisions Between ODI Substitution Method Tags And User strings
 3. The use of ODI APIs with parameters containing Variables
 4. Using ODI Variables To Lower Maintenance Costs
 5. How To Use ODI Variables And The OdiSendMail Tool For Prompting EMail Addresses At Runtime ?
 6. Is It Possible To Assign A Value To An ODI Variable From A Jython Script ?
 7. ODI Variables and Jython scripts
 8. Using ODI Variables As The Input Parameters And To Capture The Output Parameters Of A Stored Procedure
 9. Programming ODI To Automatically Purge The Operator Journal
 Commonly Asked Questions
 1. Displaying ODI Variable Value In ODI Operator Log
 2. How Is It Possible To Initialize ODI Variables Using OPTIONAL Parameters When Launching startscen Scripts (.sh and .bat)?
 3. Initializing Sets of Package Variables in a specific Package
 4. Referencing an ODI Variable From The Value Definition Of Another
 5. How to set an ODI Variable [B] value with the value of another ODI Variable [A]?
 6. How To Concatenate Values Of 2 ODI Variables.
 7. Is It Possible To Evaluate Expressions In ODI Variables?
 8. How To Use AN ODI Variable To Store A Connection URL Command Line
 9. How To Export The Current ODI Session Number Into A file ?
 10. Is It Possible To Insert The Date Into The Filename Of An Sql Loader ".bad" File?
 11. ODI Interface, Procedure and Scenario Variable Generation
 12. Is It Possible To Retrieve The Name Of The Current ODI User In An ODI Variable ?
 13. How Can We Send A Value Through An ODI Variable To A Scenario (startscen)?
 14. I have a parent Scenario and I need to pass the name previous step for the child scenario, more precisely I need to pass this name for the first step of child scenarios.
 15. How to increment DATE type Variables In ODI ?
 16.  Is It Possible To Retrieve, In An Parent Scenario, The Value Of An ODI Variable Which Is Set In A Child Scenario In Order To Be Able To Control The Parent Scenario Workflow ?
 17.  How To Pass Variable Values From A Parent To A Child Scenario In ODI ?
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.