topic Re: Example of using tOracleSP in Talend Studio

Example of using tOracleSP

Anonymous — Sat, 16 Nov 2024 12:38:29 GMT

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.

Re: Example of using tOracleSP

Anonymous — Thu, 06 Oct 2011 20:10:42 GMT

Nobody has an example of using tOracleSP?

Re: Example of using tOracleSP

Anonymous — Mon, 12 May 2014 23:09:01 GMT

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