One Star

tOracleSP - how to use the output of the stored procedure

Hello,
I don't know how to well use the tOracleSP component. Here is my problem:
I have a datatable (Oracle), for each row of the table I have to pass the id of the row in the Stored Procedure and the stored procedure give me back another id, that i wan't to store and reuse after.
I really don't know how to link all these things.
Thanks for your help
15 REPLIES
Community Manager

Re: tOracleSP - how to use the output of the stored procedure

Hello
Link the tOracleInput(query data from id column) to tOracleSP, on tOracleSP, add a external column 'another_id' as output paramter column. (see the screenshot)
Best regards
shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: tOracleSP - how to use the output of the stored procedure

Thanks a lot, it works!
One Star

Re: tOracleSP - how to use the output of the stored procedure

hum i tryed something and it doesn't work anymore!
here is the stack trace:
Exception in component tOracleSP_1
java.sql.SQLException: ORA-06550: line 1, column 13:
PLS-00306: wrong number or types of arguments in call to 'myFunction'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

Impossible to make it work, i don't understand....
One Star

Re: tOracleSP - how to use the output of the stored procedure

okay, sorry! it works
in the parameters of the tOracleSP component i add the out parameters, and i shouldn't
thanks again
One Star

Re: tOracleSP - how to use the output of the stored procedure

Hello,
I'm using tOracleSP component for calling a procedure and it works good.
My data is comming from tInputStream, passing by tMap and saving into my database using tOracleSP.
my question is who can I call my procedure each five minutes? So I want to save data into tables each 5 minutes.
I tried to use tsleep but I did not work.
thank you.
Community Manager

Re: tOracleSP - how to use the output of the stored procedure

Hello
my question is who can I call my procedure each five minutes? So I want to save data into tables each 5 minutes.

You can use a tInfiniteLoop to iterate your job in each 5 minutes.
Best regards

shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: tOracleSP - how to use the output of the stored procedure

How to pass parameter that is in my case a field to a stored procedure...
I have a table whose Ids needs to be fetched and passed to the stored procedure...Request you to kindly help me on this
Moderator

Re: tOracleSP - how to use the output of the stored procedure

Hi, nitin_varghese
Have you checked the "Parameter" section in t<Db>sp for your case? Here is component reference TalendHelpCenter:tOracleSPwith scenario.
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: tOracleSP - how to use the output of the stored procedure

Thanks Sabrina for your quick response....
However I am still not able to pass an input field value to the stored procedure....
The stored procedure should get for EG the Per_ID as input...the procedure doesnot return any value
Moderator

Re: tOracleSP - how to use the output of the stored procedure

Hi,
Would you mind posting your current job design screenshots into forum?
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: tOracleSP - how to use the output of the stored procedure

Hi Sabrina,thats fine got the desired result (data base was not responding hence )....thanks a lot for all your help... :-)....
One Star

Re: tOracleSP - how to use the output of the stored procedure

Hi 
Please let me know how to use toracleSP.
Here is the scenario in which I work
I call the Proc and the column named status will change to a different value
Please let me know how this can be done using Toracle SP
Moderator

Re: tOracleSP - how to use the output of the stored procedure

Hi,
We can't see the screenshot on our side. Could you attach it on the forum, please? That would be great.
You should register and log in as a Community member first, then you'll get a Image upload box that allows to upload screen captures.

Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

Re: tOracleSP - how to use the output of the stored procedure

Hi 
Please let me know how to use toracleSP.
Here is the scenario in which I work
I call the Proc and the column named status will change to a different value
Please let me know how this can be done using Toracle SP

Moderator

Re: tOracleSP - how to use the output of the stored procedure

Hi,
What's the error message you are getting? Here is online component reference about:TalendHelpCenter:tOracleSP with a related scenario.
The work flow look like:tOracleConnection-->tOracleInput-->toracleSP-->output.
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.