The StoredProcedure adapter service can be configured to return multiple result sets. By default, the service can return only a maximum of 20 result sets. A new result set index cannot be added manually. To specify the required maximum number of result sets, you can use the watt.adapter.JDBC.StoredProcedureMaxCursorIndex property.

To set this property, use Integration Server Administrator and select Settings > Extended > Edit Extended Settings. Enter this property in the Extended Settings box:

where value is the required maximum number of result sets. For example, to return a maximum number of 30 result sets from the StoredProcedure service, set the property as:

The value should be greater than zero with no upper limits. However, it is recommended to provide a value within the practical limits. A large value can lead to an unpredictable behavior of the system. Instead, you can configure another StoredProcedure adapter service for the next set of result sets.

For more information about setting the watt properties, see the webMethods Integration Server Administrator’s Guide for your release.