[22 Nov 2006 12:44] Tonci Grgin
Hi Frank and thanks for helping us on MySQL connector/ODBC v5.
This is not a bug but correct and documented behavior:
If you write C programs that execute stored procedures with the CALL SQL statement, you
must set the CLIENT_MULTI_RESULTS flag when you call mysql_real_connect(), either
explicitly, or implicitly by setting CLIENT_MULTI_STATEMENTS. This is because each CALL
returns a result to indicate the call status, in addition to any results sets that might
be returned by statements executed within the procedure. To process the result of a CALL
statement, use a loop that calls mysql_next_result() to determine whether there are more
results. For an example, see Section 22.2.9, “C API Handling of Multiple Statement