Page 1 of 1

Stored Procedure that returns multiple result sets

Posted: Fri Jun 05, 2009 8:36 am
by aditya.fx
Hi,

I am using MySQLi_STMT class to execute a stored procedure from my database.
The problem is that my procedure returns multiple result sets and I am able to access only the first using MySQLi_STMT::result_metadata.

I can retrieve data from multiple result sets if I use MySQLi::multi_query and then by MySQLi::next_result().

Is there any way I can do this using MySQLi_STMT?

Thanks In Advance.