Execute Stored Procedure
Use the Execute Stored Procedure action to execute an SQL stored procedure.
Complete the following steps to use the Execute Stored Procedure action in your workflow:
1. Drag the Execute Stored Procedure action under SQL Connector to the canvas, place the pointer on the action, and then click or double-click the action. The Execute Stored Procedure window opens.
2. Edit the Label, if needed. By default, the label name is the same as the action name.
3. To add an SQL connector type, refer to Supported SQL Connector Types.
If you previously added a connector type, select the appropriate Connector Type, and under Connector Name, select the connector.
4. Click TEST to validate the connector.
5. Click MAP CONNECTOR to execute the action using a connector that is different from the one that you are using to populate the input fields. In the Runtime Connector field, provide a valid SQL connector name. For more information about MAP CONNECTOR, see Using Map Connector.
6. In the Stored Procedure list, select the stored procedure.
7. Click Show additional fields.
8. In the Parameter Values field, enter comma-separated parameter values in the same order as they are defined while creating the stored procedure. For the OUT parameter, the chosen value is used while executing the procedure.
9. In the Variables field, provide comma-separated variable values, if your stored procedure has an INOUT or an OUT parameter. If your procedure has only IN parameters, this field is optional.
If used, the number of variables must be the same as the number of values selected. Also, the name of the variables must be the same as the parameters defined in the stored procedure. For IN parameter, set Variables as null.
Support for INOUT and OUT parameters is in beta stage and these parameters might not work in certain cases.
10. Click Done.
Output schema
Was this helpful?