JDBC Adapter 601 Stored Procedure

, ,
1

I am trying to execute a MS SQL 2000 stored procedure from the webMethods JDBC adapter. I’ve set up the connection to the database, I’ve created the Adapter Service for the stored procedure.

The catalog name seems to populate with the database, the schema name populates with the user and the procedure name populates with the stored procedure and that is where I am stuck.

Does webMethods not query the procedure to look for the parameters, results sets, and return set fields? Do I have it input those myself? Is anyone out there executing a stored procedure that can give me some help?

Thanks

2

Yep…

You have to input the parameter manually. At least for Oracle I have to set the inputs and output by myself.

Sometimes when you have a lot of field to fill it is boring…