Question
Cognizant technologies
US
Last activity: 21 Oct 2016 7:35 EDT
How to make the SP Name configurable in Connect SQL
We have requirement to make a SP call from pega application and we are calling it from a connect-sql rule. The data base is oracle db.
The issue here is the SP name is going to be different across the environments. We are able to invoke SP by hardcoding the name in connect-sql rule but we are not sure how to dynamically pass the sp name to connect SQL rule.
Could you please help how we can make the SP configurable in the connect-SQL rule.
Thanks,
Venkat
***Updated by Moderator: Lochan. Removed user added Ask the Expert tag. Apologies for confusion, shouldn't have been an end-user option***
Accepted Solution
Cognizant technologies
US
Thank you.
I am able to get it using {ASIS : Property}
ANZ
AU
Hi,
Please go through this GlobalResourceSetting concept and based on your requirement make a decision to go for this or not.
https://community.pega.com/sites/default/files/help_v721/procomhelpmain.htm
Virtusa IT Consulting
AE
If you want to pass SP name in runtime then use property reference in connect-sql rule, which should map the SP name from clipboard in browse tab where you should be calling your SP.