Fetching Stored Procedures

Request-Response Service must be associated with a stored procedure or a SQL statement that describes the client request an adapter has to perform.

You can use the Schema Browser view to fetch a stored procedure from a database destination.

Procedure

In the Schema Browser view, expand the database destination.
Right-click the procedure node and from the pop-up menu, click Fetch Procedure.

In the Store Procedure Download Dialog window, select the stored procedure or function you want to fetch and click OK.

You can also specify the following values.

Name	Description
Name	Name for 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 run the procedure by using a one-way operation. Clear the check box to run the procedure by using a two-way operation. If you select the one-way operation to run the procedure, the service will send a message without expecting a response.

What to do next

TIBCO ActiveMatrix Adapter for Database (TIBCO Business Studio) retrieves the signature of each stored procedure or function from the database. If you change the stored procedure or database connection while editing your project, you must return to the Store Procedure Download Dialog window and click Refresh to retrieve the changes from the database.