Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 62 Insurance
- 536.1K On-Premises Infrastructure
- 138.2K Analytics Software
- 38.6K Application Development Software
- 5.7K Cloud Platform
- 109.4K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71.1K Infrastructure Software
- 105.2K Integration
- 41.6K Security Software
ODI Load Plan input parameter variable would not accept a numeric value larger than 10 digits

I have a Load Plan that calls a scenario with three input variables. Two are alphanumeric and one is numeric.
When I call the scenario by itself, I have no issues providing input for all three variables into the dialog box.
When I run the Load Plan, the dialog box only accepts up to 10 digits for the numeric variable. My variable value is longer than that.
Does anybody have any idea what might be causing it? Is it me not doing something right or is there an ODI limitation?
Thanks
Answers
-
Hi,
What ODI version are you using ?
Adrian
-
Hi,
I had similar problems myself with numeric variables values in ODI 11g because columns are set to have 10 digits.
See below workarounds, hope will help you:
- upgrading to ODI 12c where the precision of the columns has been increased to 19 digits
- use for the variable Text or Alphanumeric Types - not numeric.Regards,
Paula