topic Re: Passing context variable into toraclesp in Talend Studio

Passing context variable into toraclesp

AJ151 — Sat, 16 Nov 2024 01:41:08 GMT

Hello everyone,

Could anyone help me with passing dynamic variable to stored procedure? Without using tfixedflow output?

Eg:

Userid

This would change so I wana use context variable in toraclesp. Is it possible??

Any input on this is very much appreciated.

Re: Passing context variable into toraclesp

manodwhb — Thu, 13 Aug 2020 01:50:08 GMT

@Aneeta Joseph , you need to maintain a table to file so that you can change any time that variable.

read the variable using tdbinput>>Main>> tflowtoiterate >>Iterate>>toraclesp and use the global variable of tflowtoiterate in toraclesp . so if you want to change variable then you can change in table ,which you used in tdbinput.

Thanks,

Manohar