topic Re: Passing Parameters to Stored Procedures in Run time in Talend Studio

Passing Parameters to Stored Procedures in Run time

VRadhakrishnan1651487711 — Fri, 15 Nov 2024 22:54:32 GMT

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

Re: Passing Parameters to Stored Procedures in Run time

gjeremy1617088143 — Fri, 20 May 2022 08:16:57 GMT

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

Re: Passing Parameters to Stored Procedures in Run time

Anonymous — Mon, 23 May 2022 07:23:53 GMT

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

Re: Passing Parameters to Stored Procedures in Run time

VRadhakrishnan1651487711 — Wed, 29 Jun 2022 04:49:35 GMT

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

Re: Passing Parameters to Stored Procedures in Run time

VRadhakrishnan1651487711 — Wed, 29 Jun 2022 04:52:47 GMT

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

Re: Passing Parameters to Stored Procedures in Run time

VRadhakrishnan1651487711 — Sun, 03 Jul 2022 09:04:26 GMT

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

Re: Passing Parameters to Stored Procedures in Run time

Anonymous — Tue, 05 Jul 2022 04:06:46 GMT

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

Re: Passing Parameters to Stored Procedures in Run time

Anonymous — Tue, 05 Jul 2022 04:08:34 GMT

Hello,

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

Re: Passing Parameters to Stored Procedures in Run time

VRadhakrishnan1651487711 — Wed, 06 Jul 2022 06:45:14 GMT

Hi @Xiaodi Shi Thanks it Worked

Re: Passing Parameters to Stored Procedures in Run time

Anonymous — Wed, 06 Jul 2022 08:26:53 GMT

Hello,

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

Best regards

Sabrina