Passing Parameters to Stored Procedures in Run time

[VRadhakrishnan1651487711]

Hi Friends

I have a scenario where the input for the stored procedures will be available in a Table. So i need to fetch those values and pass it to Oracle stored Procedure. I have tried using Oracle Input. But it is not working.. Only the tFixedflow input is working..

Can you give me idea on how to pass parameters to stored procedures in run-time

[gjeremy1617088143]

Hi @Vinothkumar Radhakrishnan​ , maybe you could try to use your tOracleInput,

link it to a tFlowToIterate iterate on your tOracleSP and use variable generated by tFlowToIterate to fill your SP param.

Send me love and kudos

[Anonymous]

Hello,

tOracleSP uses values from the incoming row as the parameters, not context variables.

Is there any specific requirement for you to pass the input parameter in runtime?

If so, please feel free to give us more description and background about it.

Best regards

Sabrina

[VRadhakrishnan1651487711]

Hi @Xiaodi Shi​ The Requirement for passing parameter during the run-time is to based on the User requirement, where request comes from CRM and respective latest information is to be fetched

[VRadhakrishnan1651487711]

Hi @guenneguez jeremy​ I tried to pass tFileInput and tFlowToiterate. But it couldn't

[VRadhakrishnan1651487711]

I have passed parameters from from cdv file. But after that it is not passing the resultset from tParseRecordset

[Anonymous]

Hello,

The tParsedRecordSet has a property in the Basic settings table called "Prev.Comp.Column List". The trick is to define a column of type Object (you can call it ProcResult) in the tOracleSP (Output) schema, and then add this column to the tOracleSP Parameters on the Basic settings tab. Set it's type to RECORD SET.

Then in the tParseRecordSet component set the "Prev.Comp.Column List" property to the RECORD SET field you just added to the tOracleSP.

Then in the tParseRecordSet component (Output) schema, add the columns that will be in the data returned by the proc.

Here is a related scenario about: TalendHelpCenter: Retrieving personal information using a stored procedure

Hope it helps.

Best regards

Sabrina

[Anonymous · Accepted solution]

Hello,

The tParsedRecordSet has a property in the Basic settings table called "Prev.Comp.Column List". The trick is to define a column of type Object (you can call it ProcResult) in the tOracleSP (Output) schema, and then add this column to the tOracleSP Parameters on the Basic settings tab. Set it's type to RECORD SET.

Then in the tParseRecordSet component set the "Prev.Comp.Column List" property to the RECORD SET field you just added to the tOracleSP.

Then in the tParseRecordSet component (Output) schema, add the columns that will be in the data returned by the proc.

Here is a related scenario about: TalendHelpCenter: Retrieving personal information using a stored procedure

Hope it helps.

Best regards

Sabrina

[VRadhakrishnan1651487711]

Hi @Xiaodi Shi​ Thanks it Worked

[Anonymous]

Hello,

Great it helps. Feel free to let us know if there is any further help we can give.

Best regards

Sabrina