How to Run a Oracle Stored Procedure in Talend

[_AnonymousUser]

Hi ,
I have created a stored procedure in oracle which has two parameters.Normally when we run in oracle it will ask the parameter values and when we enter the values it will generate the data in corresponding table with respective to the parameter values.
Same way i want to run the Oracle Stored procedure in Talend by passing two parameters.
Please Suggest me which transformations should i use.Some one explain me step by step as am very new to Talend.
Please help me out as soon as possible.

Thanks,
Praveen Kumar

[Anonymous]

Maybe I have to move the last subject about tEsbProvider and subjobs to another post.
Thanks a lot for your help!

[Anonymous]

Hi javix
Using oncomponentOK instead of OnsubjobOK, link it from tHashOutput_2 to tHashInput_1. Please see my screenshot.
Shong

[_AnonymousUser]

Hey SHNG,
I had a looked at your website and saw that you do a great contribution to open source and Talend.

[_AnonymousUser]

I have a question on stored proc: How you guys are creating the stored proc in Talend Studio? Appreciate your help in advance.
Thanks,
Ayan

[Anonymous]

Hi Ayan,
For your requirment, could you please refer to KB article about: TalendHelpCenter:Calling a stored procedure or function.
Best regards
Sabrina

[YPMAL]

DECLARE
id number:=10;
name VARCHAR2(20);
BEGIN
PUT_LINE(); ---this is my stored procedure containing one DBMS_OUT.put_line('xyz') only
NAME:=GET_NEXT_LINE(); ---this is function i have used to get values from buffer
DBMSOUTPUT(id,name); --again procedure call i am using it to store return value in my table
END;

so this is my complete block of code..
please tell me which component i can use to write it in talend..
also please tell where can i give (SET SERVEROUTPUT On command in talend before executing my block of code

[Anonymous]

Hi yogeshmalekar,
What's the DB you are using?
 Have you already checked talend tXXXSP component which is used to offers a convenient way to centralize multiple or complex queries in a database and call them easily to see if it works?
Best regards
Sabrina