Adapter for JDBC 10.3 | webMethods Adapter for JDBC Documentation | webMethods Adapter for JDBC Installation and User’s Documentation | Adapter Services | Configuring StoredProcedure Services | Considerations when Configuring StoredProcedure Adapter Services
 
Considerations when Configuring StoredProcedure Adapter Services
You must consider the following restrictions when configuring StoredProcedure services:
*The adapter StoredProcedure service does not support stored procedures that have Array or Struct as OUT parameters. You can use the StoredProcedureWithSignature service instead. For information on configuring StoredProcedureWithSignature service, see Configuring StoredProcedureWithSignature Services.
*When operating on a MySQL database, the adapter StoredProcedure service supports stored procedures, but does not support functions. To call functions, use the StoredProcedureWithSignature service template instead. For more information about configuring StoredProcedureWithSignature services, see Configuring StoredProcedureWithSignature Services.
*MySQL 5.0.x does not support stored procedure and function names containing spaces.
*When using SAP HANA database, ResultSet tab cannot be configured because the cursor cannot be returned as output in SAP HANA stored procedures.