Passing Parameter from tFileInput to tOracleSp and populate the tables

[VRadhakrishnan1651487711]

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

[Anonymous]

Hi

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

[VRadhakrishnan1651487711 · Accepted solution]

Hi Shong

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

Thanks.

[Anonymous]

Great, thanks for confirmation and coming back to us!