"java.lang.NumberFormatException: For input string" Error while Clicking the "GENERATE DDL" Option on Model
(Doc ID 2197183.1)
Last updated on JUNE 16, 2022
Applies to:Oracle Data Integrator - Version 220.127.116.11.0 to 18.104.22.168.2 [Release 11gR1 to 12c]
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 Some Other Name
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!
In this Document