Run a Stored Procedure

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

Screen



Screen



Good to Know

How to Start

  1. On the Application Explorer screen, do one of these:
  2. Do one of these:
    • Add an activity:
      1. In the Process Builder, go to the Activity Library, and open the Database Database icon tab.
      2. On the Database Database icon tab, drag the Stored Procedure Stored Procedure icon activity onto your process.
    • 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 Add Token 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.