Show TOC

Procedure documentationCreate a Dynamic Entry List with a JDBC-Based Stored Procedure Locate this document in the navigation structure

Procedure

  1. In the Entry List tab in the Control Properties dialog box, choose Dynamic from the Entry list set of radio buttons. The Find Data Service dialog box is displayed.

  2. Locate the stored procedure:

    1. From the System drop-down list, choose the JDBC-based database containing the stored procedure that you require.

    2. In the Look for combo box, enter the name of the stored procedure (without the prefix) or enter an asterisk (*).

    3. Click Search and select your stored procedure from the Select data service list.

  3. Using the Input and Output drop-down lists, choose the ports of the data service through which the data should be channeled

    1. Input port will always be displayed as INPUT. If displayed as disabled (gray), this indicates that no input values are required by the stored procedure.

    2. Output port can be OUTPUT (usually a single record value) or RESULT (a record set, or table). Usually, you will select RESULT.

  4. Because the fields of the stored procedure are returned dynamically, you need to first display the fields so that Visual Composer can store them. To do so:

    1. Click Add Fields. The Test Data Service dialog box is displayed.

    2. In the Input pane at the left, enter values for all required fields (those with asterisks).

    3. Click Execute. The returned results are displayed in the main pane.

    4. Click Finish. Visual Composer saves the fields of type Text string.

  5. In the Assigned Value column of the Input port table, you can see the input value that you entered previously in the Test Data Service dialog box. In the Output port table under it, select the source field from which the VALUE should be taken and the corresponding field from which the display TEXT should be taken. The fields in the list are the text fields that were displayed in the results pane of the Test Data Service dialog box.

  6. Click Close.

    Note Note

    You can use JDBC-based stored procedures in a similar manner to create Value Help in your model. See Adding Value Help to Your Model.

    End of the note.