Stored Procedure Caller
Executes a stored procedure with input/output parameters and captures the result set. Maps output parameters back to PAD variables.
Sign in or create a free account to copy this script.
Provided as-is, without warranty of any kind. Review and test each pattern in a non-production environment before deploying it to live automations. See our Terms.
Problem this solves
Calling SPs with output params is poorly documented for PAD.
Dependencies
- Connection String Builder
- SQL Query Runner
- Config File Reader
- Credential Vault Reader