Execute Stored Procedure (Deprecated)
Use Execute Stored Procedure for new workflows. Use Argument Mappings for In, Out, and InOut parameters. Consume Result Table and map returned arguments to their destinations.
Keep the existing node when maintaining a legacy workflow until its mappings and downstream bindings have been migrated and tested. The current activity is a replacement, not a drop-in change to the old output schema.
Description
The Execute Stored Procedure activity runs a predefined stored procedure on the connected database. It enables workflows to invoke complex, secure, and optimized database logic that is maintained at the database layer.
Common settings
Use Process Data to bind supported inputs to workflow values or upstream outputs. See Common Activity Features for shared execution, error-handling, and output-persistence settings. Availability depends on the activity.
Design-Time Configuration
The following properties define how the stored procedure is executed.
Connection Type
Specifies the database engine (for example, SQL Server, Oracle, MySQL, PostgreSQL). Selecting the correct type ensures compatibility with the target database.
Connection Name
Select a preconfigured database connection that provides secure access to the database server.
Schema
Specifies the database schema that contains the stored procedure.
Stored Procedure Name
Specifies the name of the stored procedure to execute. The procedure must exist within the selected schema and database.
Stored Procedure Arguments
Defines the input parameters required by the stored procedure. These values can be constants, variables, or expressions from the workflow, enabling dynamic execution.
Timeout
Specifies the maximum time (in seconds) the activity will wait for the stored procedure to complete. The default value is 600 seconds.
Outputs
Output
Returns the result produced by the stored procedure. This may include:
- Result sets (if the procedure returns data)
- Output parameters
- Status or execution values
The output can be used in subsequent workflow activities.
Execution settings
Configure Wait All Incoming when execution paths converge, and On Error for failure handling. Select Inherit where available to use the workflow-level error policy.