Suggest to have an OOTB Connect-SP (Stored Procedure) Rule and new Activity Method
I would suggest Pega to have an new connector Rule Connect-SP to connect with Stored Procedures in future version, this Rule may have tabs including Input Parameters, Output Parameters and Results for Stored Procedures. Also, a new Activity Method Connect-SP to be added to utilize the connector.
Since lots of my client projects have lots of SP calls, these include read and write with transactions, exiting Connect-SQL rule has to work with Activities, Data Transforms and even Java code to achieve this, instead, we may consider having an OOTB rules. Thanks.