Mysql C API调用存储过程的问题，error 2014

执行一次存储过程后，mysql_real_query再执行其他sql语句的时候，总是提示

Commands out of sync; you can't run this command now;

解决办法，代码片段：

if (0 != mysql_real_query(mysql_Conn, sql, (unsigned long)strlen(sql)))

{
setError();
}

do 
{
mysql_res = mysql_store_result(mysql_Conn);
if (!mysql_res)
{
mysql_free_result(mysql_res);
continue;

}

mysql_free_result(mysql_res);

} while (0 == mysql_next_result(mysql_Conn);