Forum Stats

  • 3,827,605 Users
  • 2,260,798 Discussions
  • 7,897,313 Comments

Discussions

PL/SQL block not taking input parameters from ODI procedure

Errendous
Errendous Member Posts: 4 Red Ribbon

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

.

Tagged: