mysql_stmt_next_result for queries returning a single result set
Posted by: Tony Izzo
Date: September 28, 2012 02:32PM

I'm interested in using the mysql_stmt_next_result() API for retrieving results for a stored procedure call which may or may not return multiple result sets. I am trying to determine whether I can use this same method for a plain old SQL prepared SELECT statement that returns only a single result set, or if it is only permitted for executing a CALL.

In other words, if I pass an arbitrary statement into a function that prepares, binds, and executes that statement, does my function need to handle two separate execution paths for CALL and SELECT statements, or will a function that correctly handles CALL statements returning an arbitrary number of result sets also work with a normal SELECT? Thanks.


Options: ReplyQuote

Written By
mysql_stmt_next_result for queries returning a single result set
September 28, 2012 02:32PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.