tOracleSP - how to use the output of the stored procedure

[Anonymous]

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

[Anonymous]

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

[Anonymous]

Thanks a lot, it works!

[Anonymous]

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....

[Anonymous]

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

[Anonymous]

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.

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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