Mapping the Result Set

TIBCO Business Studio automatically populates the Database tab with the return parameters from the stored procedure.

Note:
  • Despite being similar in appearance, the return parameters from the stored procedure are not created as parameters of the process. For this reason, they are visible only on the Database tab, and not in the Project Explorer.
  • You should also check any stored procedure parameters created on the Database tab to see that they have been created correctly.

Each input and output parameter defined in the stored procedure must be mapped to a corresponding data field or parameter in the process.

The process data field or parameter can be:

  • a basic type data field or parameter
  • an existing business object model object
  • (for values returned to the process from the stored procedure) a new business object model object. )
Note: You must ensure that the data type of your selected data field or formal parameter matches the data type of the database parameter it is being mapped to. TIBCO Business Studio does not validate this.

You map parameters using the Database tab of the Properties view.