Run a Stored Procedure

To run a stored procedure, do the procedure in this topic.

Figure: Stored Procedure > Basic tab

Basic tab
Figure: Stored Procedure > Advanced tab

Advanced tab

Examples

Good to Know

How to Start

  1. On the App Explorer screen, do one of these:
  2. Do one of these:
    • Add an activity:
      1. In the Process Builder, in the Activity Library, open the Database tab.

        Open Database tab
      2. On the Database tab, drag the Stored Procedure activity onto your process.

        Drag Stored Procedure activity
    • Change an activity:
      1. In your process, double-click your activity.
    • Click Stored Procedure Stored Procedure icon.

Procedure

  1. To run a stored procedure, do one of these.
    • To run a basic stored procedure:
      1. On the Stored Procedure screen, in the Basic tab, in the Database list, select your database access token.

        To create a new access token, click Create Add Token icon. For more information, refer to Access Token for Database.

      2. In the Stored Procedure Name list, select your stored procedure.
      3. In the Value/Attr. Name field, enter the value of the stored procedure parameter, or drag a process data variable from the Process Data screen.
      4. To specify the input and output options for the stored procedure, complete this field as necessary.
        Field Name Definition

        In/Out

        Function:
        Specifies the in/out parameters for the stored procedure.
        Accepted Values:
        • Input - Specifies that the parameter is an input value for the stored procedure.
        • Output - Specifies that the parameter is an output value for the stored procedure.
        • InputOutput - Specifies that the parameter can be input/output value for the stored procedure.
        • ReturnValue - Specifies that the parameter is a return value for the stored procedure.
        Default Value:
        None
        Accepts Process Data Variables:
        No
      5. In the Data Type list, select the data type of the stored procedure parameter.
      6. In the Size field, enter the size of the input parameter for the stored procedure.
    • To run an advanced stored procedure with a SQL:
      1. On the Stored Procedure screen, click Advanced tab. .
      2. On the Advanced tab in the Database list, select your database access token.
      3. In the SQL field, enter a SQL statement to run on the database.​ You can drag the stored procedure name from Stored Procedure Name list to create a SQL query.