Run a Stored Procedure

Good to Know

• In most text fields, you can use process data variables as an alternative to literal data values.
• You can configure whether this activity waits for other activities before it runs.

  For more information, refer to How Do I Configure an Activity to Wait for Other Incoming Activities?

• Some information about third-party integrations is outside the scope of the AgilePoint NX Product Documentation. It is the responsibility of the vendors who create and maintain these technologies to provide this information. This includes specific business use cases and examples; explanations for third-party concepts; details about the data models and input and output data formats for third-party technologies; and various types of IDs, URL patterns, connection string formats, or other technical information that is specific to the third-party technologies. For more information, refer to Where Can I Find Information and Examples for Third-Party Integrations?

How to Start

1. On the App Explorer screen, do one of these:
   • Open a Process.
   • Create a Process.
2. Do one of these:
   • Add an activity:
     1. In Process Builder, in the Activity Library, 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 Create . 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.