Adding operations that are based on calls to stored procedures

You can create operations that call any stored procedure that is deployed in your database.

Before you begin

The stored procedure must be deployed on the database that is associated with the Web service in which you want to create the operation.

About this task

Restrictions:
  • Each operation within a Web service must have a unique name.
  • You can include one stored procedure call per operation.

Procedure

To add to a Web service an operation that calls a stored procedure:

What to do next

If the stored procedure returns result sets and always accepts the same input values, use the Edit Operation wizard to specify the input values. The workbench then runs the stored procedure to generate an XML schema that describes the result sets in detail.

Feedback