Adding a Stored Procedure Using the Browse Method

Select the Service Interface tab in the database service editor.
Right-click the interface perspective and select Add Stored Procedure Operation|Browse for Stored Procedure Operation from the menu to invoke the Stored Procedure Selection dialog.
Select one or more stored procedures from the list and click OK.
A new operation with the same name as each selected stored procedure is added to the interface. An endpoint corresponding to the JDBC connection profile exposing the stored procedures is also added, if not already added to the service interface.
Note
If a stored procedure is already exposed from an existing operation, it does not appear in this list.
Expand the Operation Parameters panel.
- The Parameters tab describes the parameters that are sent to this operation and a return value, if any.
- The Result Sets tab displays a list of the different result sets the operation returns.
  Select the result set in the list and click Edit for a description of the data each row in the result set contains.
Expand the Properties Panel.
The Source tab describes the stored procedure. The Basic Properties tab lists properties, which you can manually edit.
To change the stored procedure, click Browse to select a different stored procedure using the same dialog you used to create a new operation.
Save your service file to create your database service.