Run a Stored Procedure

Stored Procedure > Basic Screen

Good to Know

• In most text fields, you can use process data variables as an alternative to literal data values.

How to Start

1. On the Organizer, do one of these:
   • Open a process.
   • Create a process.
2. Do one of these:
   • Add an activity:
     1. In the Process Builder, go to the Activity Library, and open the Database tab.
     2. On the Database tab, drag the Stored Procedure activity onto your process.
   • Change an activity:
     1. In your process, double-click your activity.
   • Click Stored Procedure .

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 . For more information, refer to New Database Access Token.

     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. InputOuput - 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.