En

Execute Stored Procedure#

Execute the stored procedure.

Connection String[Text] Connection string to the database. The string is specified according to the selected provider. When using an already open connection, do not set this property, but specify in the "Connection Reference" property a variable with the current connection object.
User[Text] Username for authentication.
Password[Text/SecureString] Password for authentication.
SQL ProviderSelect SQL provider.
Connection Reference[Link] SQL connection object. The variable name in this property must match the variable name in the "Connection Reference" property of the "Connect" block from the Databases group that was previously used to connect to SQL.
Procedure Name[Text] Name of the stored procedure on the server.
Input Parameters

[Dictionary] Input parameters for the stored procedure. The dictionary must contain key values as parameter names without the @ symbol. The values of the dictionary are the parameter values.

By default, the parameter type is NVarChar(MAX).

Output Parameters[List] Output parameters for the stored procedure. The list must contain parameter names without the @ symbol. To obtain the return value of the procedure, specify the name "ReturnValue".
Result Data TableIf enabled, the result of execution will be a data table, and the "Output Parameters" property will be ignored.
Timeout[Number] Timeout for executing the query in seconds.
Result

[Dictionary/Data Table] Result of executing the stored procedure.

If the "Result Data Table" property is enabled, the type of the output property will be Data Table.

Otherwise, the type of the output property will be Dictionary. The key of the dictionary is the name of the output parameter, and the value of the dictionary is the value of the output parameter.

Error Handling Level

Select the error handling level. Possible values:

  • "Default" - by default;
  • "Ignore" - errors are ignored;
  • "Handle" - errors are handled.

If "Default" is selected, the value of the "Start" block of this diagram will be used.

Message Level

Select the message level that blocks will output during operation. Possible values:

  • "Default" - by default;
  • "Release" - output is disabled;
  • "Debug" - main information output;
  • "Detailed" - detailed information output.

If "Default" is selected, the value of the "Start" block of this diagram will be used.

Error Text[Text] Returns detailed information about the error in case of incorrect execution of the block.