Example of using tOracleSP

[Anonymous]

Hello,
I need to test the component tOracleSP, using a simple stored procedure:
CREATE OR REPLACE PROCEDURE TESTPRC
(
in_num IN number ,
out_lib OUT varchar2
) IS
lib varchar2(10) := '';
BEGIN
if in_num=1 then lib:='ONE';
elsif in_num=2 then lib:='TWO';
else lib:='OTHER';
end if;
out_lib := lib;
END TESTPRC;
/
Please, someone can show me an example of using tOracleSP, and passing parameters to properly execute the SP?
Thank you in advance.

[Anonymous]

Nobody has an example of using tOracleSP?

[Anonymous]

Hi,
I used in my project and i have taken help from the below link.
It is very useful and explained very nicely.

https://help.talend.com/search/all?query=tOracleSP&content-lang=en