The ADO Stored Procedure action enables you to automate the execution of stored procedures using ADO. The action property pages helps you build your connection string, displays a list of stored procedures in the target database, and will retrieve the parameters for the selected stored procedure. The value of each input parameter can be set, and the out values and return values can be saved to a variable. It is important to set "Stored Procedure Returns Recordset" correctly, as this controls how the action internally calls the stored procedure. |