Action Description - Descriptive text that can be used to identify this particular action in the Actions list.
Transaction Name – Name of the transaction that this action should use. This name should match the name defined on the corresponding Begin Database Transaction Action.
Stored Procedure Name – Enter the name of the Stored Procedure that this action should execute.
Parameters Collection
Define the stored procedures parameters by adding rows to the parameters grid.
•Name Column
Enter the name of the parameter
•Type
Select the parameter type
•Value
Enter the value of the parameter
•Null
Check to indicate the parameter is null
•Size
The size of the parameter
•Direction
Define the direction of the parameter
•Output Property
A Shared Property key to copy the parameter
value to upon execution completion.
Store first result in shared property – Allows you to read information from a database and share the information with other actions through Shared Properties and Expansion variables.
Expansion variables can be used to set the stored procedure name, parameter names, parameter values, and parameter output properties.
See Transacted Stored Procedure for more information.