Call stored procedure

Call stored procedure activity executes a desired stored procedure in the database and returns the result.

Usage examples can be found at this link .
* Connection name The defined connection name before is chosen from the dropdown.
Param1 The value to be assigned to the first parameter is written.
Param2 The value to be assigned to the second parameter is written.
Param3 The value to be assigned to the third parameter is written.
Param4 The value to be assigned to the fourth parameter is written.
Param5 The value to be assigned to the fifth parameter is written.
Parameters If it is desired to put multiple parameters, parameters are written.
*Stored procedure name The stored procedure name is written. The question marks should be added as many as the number of parameters to be used.
*Result dataset name The reference name is given to the dataset which will create in this field.

Note: * Fields selected with are required, others are optional.

Connection name example

You can use the Connection name as shown in the example.

robustaConnection

Param1 example

You can use the Param1 as shown in the example.

[‘1’, ‘STRING’, ‘in’, ‘2314589’]

Param2 example

You can use the Param2 as shown in the example.

[‘2’, ‘STRING’, ‘in’, ‘${companyName}’]

Param3 example

You can use the Param3 as shown in the example.

[‘3’, ‘STRING’, ‘in’, ‘${companyName}’]

Param4 example

You can use the Param4 as shown in the example.

[‘4’, ‘STRING’, ‘in’, ‘${companyName}’]

Param5 example

You can use the Param5 as shown in the example.

[‘5’, ‘STRING’, ‘in’, ‘${companyName}’]

Parameters example

You can use the Parameters as shown in the example.

[[‘1’, ‘STRING’, ‘in’, ‘2314589’], [‘2’, ‘STRING’, ‘in’, ‘${companyName}’]]

Stored procedure name example

You can use the Stored procedure name as shown in the example.

CALL robusta.getCustomerInfo(?,?);

Result dataset name example

You can use the Query sql as shown in the example.

employeesDataset