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).