You call runProcedure with ordinary parameters as
where @parameterList is a list created as
If a you have parameters of the type "credential", you also need to pass a list of credentials
How do you populate @credentialList?
- First you must add an actual parameter that binds the parameter name to the name of the credential, like
where "procCred" is the name of the Credential parameter.
- Next you must define a credential of the same name. The credential has three fields - credentialName, userName, and password
You can add both of these as many times as you need to, based on the number of credential parameters.
- To avoid putting cleartext passwords into the code, you can use getFullCredential command
This approach avoids the password ever appearing in the clear via 'ps'.