topic Re: Passing Parameter from tFileInput to tOracleSp and populate the tables in Talend Studio

Passing Parameter from tFileInput to tOracleSp and populate the tables

VRadhakrishnan1651487711 — Fri, 15 Nov 2024 22:46:52 GMT

Hi Guys

I am trying to pass the parameters from tFileInput to OracleSp. But the data is not populating. Attached the jobs of both using tFileInput and tFixedflow input

Kindly help me out get this working..

Re: Passing Parameter from tFileInput to tOracleSp and populate the tables

Anonymous — Mon, 04 Jul 2022 07:21:25 GMT

Can you confirm it is working as expected using tFixedFlowInput component? From the screenshot, I see tOracleSP has the output. tOracleSP requires the parameter value from the input data, so you should use a tFixedFlowInput to generate the current data if you are using a tFlowToItearate records one by one.

Regards

Shong

Re: Passing Parameter from tFileInput to tOracleSp and populate the tables

VRadhakrishnan1651487711 — Mon, 04 Jul 2022 07:24:34 GMT

Hi Shong

Issue Resolved. As i passed the ResultSet Parameter from the InputFile Component. After removing the ResultSet Field it works..

Thanks.

Re: Passing Parameter from tFileInput to tOracleSp and populate the tables

Anonymous — Mon, 04 Jul 2022 07:30:54 GMT

Great, thanks for confirmation and coming back to us!