My Oracle Support Banner

ODI 11g Generate DDL Requires a Completely New Name or a Numeric Value at the End (Doc ID 2493761.1)

Last updated on JUNE 16, 2022

Applies to:

Oracle Data Integrator - Version to [Release 11gR1 to 12c]
Information in this document applies to any platform.


In Oracle Data Integrator (ODI) 11g, the following error occurs when attempting to generate a new DDL Procedure if the name is not completely changed, or a numeric value is not used at the end of the name.

java.lang.NumberFormatException: For input string: ""
  at java.lang.NumberFormatException.forInputString(
  at java.lang.Integer.parseInt(
  at java.lang.Integer.parseInt(
  at com.sunopsis.graphical.dialog.SnpsDialogADHGenerateDDL.getTentativeTrtName(
  at com.sunopsis.graphical.dialog.SnpsDialogADHGenerateDDL.resetName(
  at com.sunopsis.graphical.dialog.SnpsDialogADHGenerateDDL.initialize(
  at com.sunopsis.graphical.dialog.SnpsDialogADHGenerateDDL.(
  at oracle.odi.ui.action.SnpsPopUpActionADHGenerateDDL.actionPerformed(
  at oracle.odi.ui.SnpsActionControler.handleEvent(
  at oracle.ide.controller.IdeAction$ControllerDelegatingController.handleEvent(
  at oracle.ide.controller.IdeAction.performAction(

The issue can be reproduced at will with the following steps:

  1. Create DDL using <SCHEMA> > <NAME> > Right Click > Generate DDL
  2. Change Procedure Name from 'DDL <NAME> 001' to 'DDL <NAME> PROD' Generation Folder: <NAME>_SVN.First Folder
  3. Generate the DDL
  4. Create new DDL using <SCHEMA> > <NAME> > Right Click > Generate DDL
  5. DDL UI does not appear and the error message pops up

The issue does not occur with the following names:

Each of the above names will increment the trailing numeric value by 1, except '<NAME> DDL' which will not have a Numeric value at the end.


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

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