Adding a Stored Procedure Using Drag-and-Drop

Select the Service Interface page in the database service editor.
Connect to your database connection profile in the Enterprise Explorer by selecting Enterprise Explorer|Databases, and navigate to the list of stored procedures after the contents node in the tree.
If you have not yet created your connection profile, right-click Databases and select New to create a new connection profile. See Creating a JDBC Connection Profile for instructions.
Drag your desired stored procedure from the connection profile in the Enterprise Explorer to the interface object in the service diagram.
The database service now contains a stored procedure operation.
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 database service.