How to call database package in ODI? The db package contains list of functions and out of those I want to call only one function in ODI

Question

There's a database package and it contains list of functions. Out of the list, I want to call one function in ODI12c. I tried to create an ODI procedure and within that called the db package using .(return variable); However, when I execute this ODI procedure, it fails with error saying " is not a procedure or is undefined. Any help is appreciated. Thanks

I tried to create an ODI procedure and within that called the db package using .(return variable);

Error: is not a procedure or is undefined.

Answer 1

As this is a call to function, there has to be a variable created in ODI procedure to which the function returns the value. So I did a small change and it worked.

DECLARE 
var1 varchar2(1000);
v_ret Boolean;
BEGIN
     v_ret := <Function Call>;
END;