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?