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]

Hi,
Would you mind posting your current job design screenshots into forum?
Best regards
Sabrina

[Anonymous]

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

[_AnonymousUser]

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

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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