This content has been marked as final. Show 4 replies
Correct me if I am wrong.
you want to call oracle procedure in ODI, if it is correct then compile the oracle procedure in DB level.
In ODi, create new ODI procedure and (as per your the requirement) commoand on source/command on target write below code and call the ODi procedure in package