Skip to main content
Version: Current

Execute Stored Procedure

Description​

The Execute Stored Procedure activity executes a stored procedure on a connected database.

It allows workflow data to be passed to the stored procedure through input arguments and retrieves output arguments and result data produced by the procedure.

Stored procedures can encapsulate database operations such as data retrieval, insertion, updates, deletion, validation, and other database-specific business logic.

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 activity connects to the database and executes the stored procedure.

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 defines the server, credentials, and security settings.

Schema​

Specifies the database schema that contains the target stored procedure.

Stored Procedure​

Specifies the name of the stored procedure to be executed.

Argument Mappings​

Defines how workflow data is passed to and retrieved from the stored procedure.

You can map workflow expressions to the procedure's arguments and specify the appropriate direction:

  • In – Passes a value from the workflow to the stored procedure.
  • Out – Retrieves a value returned by the stored procedure.
  • InOut – Passes a value to the stored procedure and retrieves the updated value after execution.

Timeout​

Specifies the maximum time (in seconds) that the activity will wait for the stored procedure to complete.

The default value is 600 seconds.

Outputs​

Result Table​

Returns an IbDataTable containing the result set produced by the stored procedure.

Each row in the returned result set is represented as a row in the DataTable, with columns corresponding to the fields returned by the stored procedure.

If the stored procedure does not return a result set, the Result Table will contain no rows.

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