Call Procedure Via JDBC Activity

Use the Call procedure via JDBC activity to call a database procedure using the specified JDBC connection.

Usage

Complete the following properties to use this activity:

• Call Procedure - Specify the following information or click the Variable Reference icon to choose a variable:
  • Procedure Name - Enter the name of the database procedure to call.
  • Persist Table - Check this check box to perform the query against data that has already been summarized. This helps reduce the query time and database load.
  • Read all columns from the procedure - Check this check box to read all the columns from the call.
  • Stored procedure inputs - Click Add and specify the following information:
    • Parameter name - Enter the appropriate parameter name.
    • Parameter type - Choose the appropriate data type from the drop-down list.
    • Parameter value type - Choose the appropriate data type from the drop-down list.
    • Parameter value: Enter the appropriate parameter value.
• Columns to read - Click Add to enter a Column Name and choose the Column Type from drop-down list.
• Number of rows to return - Enter the maximum number of rows to display. The default is 200.