"java.lang.NumberFormatException: For input string" Error while Clicking the "GENERATE DDL" Option on Model
(Doc ID 2197183.1)
Last updated on SEPTEMBER 11, 2018
Applies to:Oracle Data Integrator - Version 220.127.116.11.0 and later
Information in this document applies to any platform.
Generating DDL on ODI Model fails with the following error even before the "generate ddl " Wizard opens:
The error has been found to occur in two cases so far:
If a procedure already exists with the same name for the specific Model.
The following error may be seen:
When a procedure exists for the specific model AND the name was changed from the default name.
Original name: DDL Oracle BI Applications 001
Changed name: DDL Oracle BI Applications Contract Header Start Date
Once the name was changed and the number removed, the error presented.
The error may present as:
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!