Selecting a Stored Procedure From the Database

You can select a stored procedure from the database.

Procedure

  1. Select the service task that you want to use to call the database.
  2. On the General tab of the Properties view, click the picker next to the Name field in the right-hand pane.
    • If a system participant is already assigned to the database service task, and that system participant is mapped to a database connection profile:

      TIBCO Business Studio opens the database connection and displays the Pick Stored Procedure dialog.

      Expand the database through the Catalogs and Schemas until you find the stored procedure you want, select it and click OK. The selected stored procedure is displayed in the Name field.

    • If a system participant is already assigned to the database service task but is not mapped to a database connection profile, or if no system participant is assigned to the database service task:

      The Connection Profile Selection dialog is displayed.

      1. Select the database connection profile that you want to use, then click OK. TIBCO Business Studio opens that database connection and displays the Pick Stored Procedure dialog.
      2. Expand the database through the Catalogs and Schemas until you find the stored procedure you want, select it and click OK. The selected stored procedure is displayed in the Namefield.

      A system participant is also automatically created or updated and assigned to the database service task.