Considerations when Configuring StoredProcedureWithSignature Adapter Services
You must consider the following restrictions when configuring StoredProcedureWithSignature adapter services:
StoredProcedureWithSignature services cannot be used with an Informix or Sybase database (all versions).
When using Array as IN or OUT parameter in an Oracle database, the input to the IN parameter must be a Java array. The OUT parameter returns a Java array as Java data type, java.lang.Object.
When operating on a MySQL database, the adapter StoredProcedureWithSignature service supports functions, but does not support stored procedures. To call stored procedures, use the StoredProcedure service template instead. For more information about configuring StoredProcedure services, see
Configuring StoredProcedure 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.