Question

3
Replies
144
Views
doppalapudi Member since 2013 2 posts
Cognizant technologies
Posted: 4 years ago
Last activity: 3 years 11 months ago
Closed
Solved

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***

 

Data Integration
Moderation Team has archived post
Share this page LinkedIn