PL/SQL block not taking input parameters from ODI procedure

Errendous

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

.