Adding a Stored Procedure Operation

Open the database service you want to add a stored procedure to.

Select the Service Interface tab in the editor and do one of the following:

Option	Action
Select the Service Interface page in the editor	Right-click the Interface box and select Add Stored Procedure Operation > Browse for Stored Procedure Operation. Select one or more stored procedures from the list and click OK. Note: You cannot have two stored procedures from different databases with the same name. If this problem occurs, modify the spname element .of the catalog.schema.spname operation qualification to spname1. A new operation with the same name as each selected stored procedure is added to the interface. If not already added, an endpoint corresponding to the JDBC connection profile exposing the stored procedures is also added to the service interface. If a stored procedure was exposed from an existing operation, it does not appear in this list.
Open the Enterprise Explorer	Expand the database connection profile and drill down to Procedures & Functions. Drag the stored procedure you want to add to the service interface from the Enterprise Explorer to the Service editor.
Open the Tool Palette	Select Stored Procedure - Request Response and drag and drop it onto the service interface.

A stored procedure operation is added to the database service interface.

Select the operation and expand the Operation Parameters section.

Tab	Description
Parameters	Describes the parameters that are sent to this operation and any return values You can add or delete operation parameters using the Add and Delete buttons in the editor.
Result Sets	Displays a list of the different result sets the operation returns. To view the description of a result set, select the result set in the list and click Edit. To discover result sets, click Discover. To add result sets, click Add.

Select the operation and expand the Properties section.

Tab	Description
Source	Describes the source of the stored procedure. To edit a stored procedure: Click Browse and select the stored procedure. Make the changes and click OK.
Basic	Lists the operation properties. You can manually edit the properties from this location.

Select File > Save.