title: Problems calling MySQL stored procedures from C API
body: <p>I have a problem calling a stored procedure on my MySQL server using the C API.</p>
  
  <p>I use mysql_query(&amp;handle,"CALL myprocedure") but the function fails (returns 1) and error lookup gives
  the following message "Procedure myprocedure can't return a result set in the given context."
  I even tried to use mysql_real_query insted, but no better.</p>
  
  <p>I've seen a few topics about this bug, but only PHP related. So there seems to be the same problem for C programs too.</p>
  
  <p>The weird thing is that my stored procedure is not even supposed to return any result set. It just works with data in tables, doesn't  really return anything.</p>
  
  <p>Thanks for any advices.</p>