Skip to main content
Version: Current

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.

Common Capabilities​

Process Data Support​

info

This activity supports dynamic configuration using variables from the Process Data drawer.

You can bind values from Model Data, Form Data, System Data, Enterprise Variables, and Activity Outputs.

Learn more → Using Process Data

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.

Wait All Incoming​

Execution Control

Controls how this activity behaves when multiple incoming execution paths converge.

Determines whether the activity executes when:

  • any incoming path completes, or
  • all relevant paths have completed before execution

Learn more → Execution Control

On Error​

Error Handling Strategy

Defines how the workflow behaves if this activity encounters a runtime error.

Supported strategies include Fault, Continue, Suspend, and Retry.

Learn more → Error Handling