I created stored procedure in MYSQL with 6 parameters (3 IN and 3 OUT).
I checked this from mysql command line, and it worked fine:
mysql> CALL sp_ComputeClientDues('0000000001','001','1',@x, @y, @z);
Query OK, 0 rows affected, 1 warning (0.00 sec)
mysql> SELECT @x, @y, @z;
+----------+------------+------+
| @x | @y | @z |
+----------+------------+------+
| 10000.00 | 2008-10-07 | RES |
+----------+------------+------+
1 row in set (0.00 sec)
But when I try to invoke this Designer JDBC Connector query,
the last out parameter (@z) has the same value as @y.
I attached the two sql/prm files.
Design comment: Returning value of OUT parameter uses Test Value. Re-executing again the query need to check each out parameter again the Value as Null which seems not very convenient.