Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
AJ151
Contributor
Contributor

Passing context variable into toraclesp

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

Labels (4)
1 Reply
manodwhb
Champion II
Champion II

@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