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!

PL/SQL block not taking input parameters from ODI procedure

ErrendousApr 3 2022

I have created a simple pl/sql package which basically takes an in input parameters and returns a value. When I'm executing the below pl/sql block in ODI 12C procedure it's not taking the value.
When i execute this in db it works but from ODI procedure it refuse to take values.
begin
my_pkg.set_agent_name('Smith');
end;
After this when I execute below statement it returns null.
select my_pkg.get_agent_name from dual;
I'm also attaching the db package i have created to get the agent name
plsql_package.txt (519 Bytes).

Comments