Procedure Schema Information Reference

The Procedure Schema Information panel in the Store Procedure Download Dialog window contains the following options:

Name Description
Name Name of the call operation.
Catalog/Package (Optional) Only applicable to a database that has more than one catalog or package. The catalog or package in which the procedure is stored.

This name is used to resolve naming conflicts when more than one catalog or package in the database has the selected procedure with the same name.

See your database documentation for more information about catalogs and packages.

Schema (Optional) The schema is the collection of database objects. Schema objects are the logical structure that directly refer to the database data.

In TIBCO ActiveMatrix Adapter for Database (TIBCO Business Studio), this is a mandatory field for most databases. Generally, the name of the default schema has to be the same as the user name.

One Way (Optional) Select this check box to execute the procedure by using a one-way operation. Clear this check box to execute the procedure by using a two-way operation. If you select the one-way operation to execute the procedure, the service will send a message without expecting a response.