topic Re: Use output parameter from one procedure as input for another in Talend Studio

Use output parameter from one procedure as input for another

Anonymous — Tue, 13 Aug 2013 22:51:41 GMT

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

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

Anonymous — Tue, 13 Aug 2013 23:32:05 GMT

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.

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

Anonymous — Thu, 02 Jan 2014 10:49:03 GMT

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?