Execute Stored Procedure
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.
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.
Wait All Incoming
The Wait All Incoming property controls how the activity behaves when it has multiple incoming execution paths.
| Option | Description |
|---|---|
| False | The activity executes whenever any incoming path completes. Each incoming completion can trigger a separate execution. |
| All Configured Incoming | The activity executes only after all design-time (configured) incoming paths have completed. If a path is skipped at runtime due to conditional logic, the activity may wait indefinitely. |
| All Active Incoming | The activity executes only after all runtime-active incoming paths have completed. Incoming paths that are not taken due to conditions are ignored, ensuring predictable execution. |
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.
Error Handling
This activity supports the standard On Error handler, including Fault, Continue, Suspend, and Retry.
For details, see
On Error Handler.