SQL stored procedures and webmethods

Today, try to do the use of SQL stored procedures that were not made before webmethods, because the stored procedure for the database is also smattering, so first in http://www.cnblogs.com/hoojo/archive/2011/07/19/ 2110862.html to learn a bit. Write a stored procedure in SQL that has input and output, typically a good experiment.

In webmethods, you need to be prepared first: Install SQL and webmehtods, and configure SQL JDBC Adapter on the IS server. I used the sql2005 to put the database connection driver into the D:\webmethods82\IntegrationServer\packages\WmJDBCAdapter\code\jars, the corresponding datasource Class It's com.microsoft.sqlserver.jdbc.SQLServerDataSource. Make a simple SQL query to test the success of the connection.

1. Create a new adapter service and choose the store procedure type.

2,call sets the name of the DB, the owning permission, the procedure, and returns the domain.

The input and output parameters are set in the 3,parameter.

If a result set is returned in the 4,result set, then his index needs to be set.

5, run a bit, no return value, where is the problem?