One Star

Use output parameter from one procedure as input for another

Hi,
I have a stored procedure which returns a set of output parameters.
I need to be using few of the output parameters as input parameters for another stored procedure.
How do I achieve this?
It would be great if you could point me to an example and a documentation article for the same.
Thanks
Vikas
2 REPLIES
Seventeen Stars

Re: Use output parameter from one procedure as input for another

As an example tOracleSP:
Create an input flow to the tOracleSP component which contains your input AND output variables: Use tOracleSP and configure the type IN/OUT for input and output. create a output flow to e.g. tLogRow.
tFixedInputFlow ---> tOracleSP ----> tLogRow
This is a very simple design demonstrating the way how to work with tOracleSP.
One Star

Re: Use output parameter from one procedure as input for another

Hi i have a SQL Store Proc which generates an output on screen, how do i get this output to write to Excel or Log Row, i have built a connector but all i get is a header... Running the SP in SQL generates the output but as the SP is not writing the output to a table i cant find how i can get Talend to grab it? am i missing something simple here?