Configuration
The Configuration tab has the following fields.
Field |
Global Var? |
Description |
Name |
No |
The name to appear as the label for the activity in the process definition. |
Description |
No |
Short description of the activity. |
JDBC Connection |
Yes |
Path to the shared configuration resource containing the JDBC connection information. For more information about JDBC resources, see JDBC Connection . |
Schema |
Yes |
The schema in which the procedure resides. This name is used to resolve naming conflicts if more than one schema in the database has the selected procedure with the same name. The Select Schema button allows you to choose a schema from the database using the specified JDBC Connection. |
Catalog/Package |
Yes |
The catalog or package in which the procedure resides. This name is used to resolve naming conflicts if more than one catalog or package in the database has the selected procedure with the same name. This field is only applicable to databases that have more than one catalog and package. For more information about catalogs and packages, see your database documentation. The Select Catalog/Package button allows you to choose a catalog or package from the database using the specified JDBC Connection. If a schema is specified in the Schema field, only catalogs or packages in the specified schema are listed. |
Procedure/ |
Yes |
Name of the database procedure or user-defined function to call. You can use the Select Procedure/Function button to query the database for available procedures or functions once the JDBC Connection field is specified. The list of available procedures and functions are limited by the values supplied in the Schema and Catalog/Package fields. Note: The input parameters and output parameters are displayed when you use the Select Procedure/Function button. TIBCO Designer retrieves the signature of each stored procedure/function from the database once. If you change the signature while editing your project, you must click the Refresh button to retrieve the changes from the database.
|
Timeout (sec) |
Yes |
Time to wait for the procedure call to complete. If the call does not complete in the given time limit, an error is returned. |
Maximum Rows |
Yes |
The maximum number of rows to retrieve. To retrieve all rows, specify 0. |
Parameter Types |
No |
This field displays the parameters for the procedure and allows you to override the parameter type (IN, OUT, INOUT) for each parameter. |