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.
***Updated by Moderator: Lochan. Removed user added Ask the Expert tag. Apologies for confusion, shouldn't have been an end-user option***