Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

ODI API & Groovy: Procedure Options in Package

mcoeneJul 12 2022

Hi all,
I am building some automation scripts in Groovy.
One is to automatically create some of the package we are using when integrating data.
One of the step in such a package is a procedure which has 1 option. In my Groovy script, I need to set this option, but when I look at my generated package, the procedure step always shows the default value for that option.
As a test, I tried adding another option using groovy code, but this new option is also not visible in the generated package.
What am I missing?
(Groovy code relevant to the question below)
procs = procf.findByName("Proc. Initialize CDC Controle Record")
for(proc in procs) {
if(proc.getName() == "Proc. Initialize CDC Controle Record")
{ procInitCDC = proc }
}

procInitCDC.removeOption(procInitCDC.getProcedureOption("CDC_TYPE"))
procInitCDC.addOption("CDC_TYPE", ProcedureOption.OptionType.valueOf("SHORT_TEXT"),"DERIVED")
procInitCDC.addOption("CDC_TYPE_TEST", ProcedureOption.OptionType.valueOf("SHORT_TEXT"),"DERIVED")
step03 = new StepProcedure(pack, procInitCDC, "Proc. Initialize CDC Controle Record")
// I even read the options in the StepProcedure and both options show up in the log just fine
pos = step03.getProcedureOptions()
for(po in pos) {
log.append(po.getName()+" "+po.getValue()+"\n")
}

This post has been answered by mcoene on Jul 13 2022
Jump to Answer
Comments
Post Details