My Oracle Support Banner

"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 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:

'java.lang.NumberFormatException: For input string: <Number>'
    'java.lang.NumberFormatException: For input string: "12121212004'




 CASE 2:

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:

java.lang.NumberFormatException: For input string: ""





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

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

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