ODI 11g Generate DDL Requires a Completely New Name or a Numeric Value at the End
(Doc ID 2493761.1)
Last updated on FEBRUARY 03, 2019
Applies to:Oracle Data Integrator - Version 18.104.22.168.0 and later
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.
The issue can be reproduced at will with the following steps:
- Create DDL using SCOTT > TEST > Right Click > Generate DDL
- Change Procedure Name from 'DDL TEST 001' to 'DDL TEST PROD' Generation Folder: TEST_SVN.First Folder
- Generate the DDL
- Create new DDL using SCOTT > TEST > Right Click > Generate DDL
- DDL UI does not appear and the error message pops up
The issue does not occur with the following names:
- 'DDL TEST'
- 'TEST DDL'
- 'DDL TEST 234'
- 'DDL TEST PROD 009'
Each of the above names will increment the trailing numeric value by 1, except 'TEST 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