I have a stored procedure in my mysql database which returns multiple query result sets. I want to access these results in my cakephp(V3.4) project using following code statements.
$db = ConnectionManager::get(‘default’);
$stmt = $db->execute(“call mydatasp($paramlist)”);
$result = array();
try{
do
{
$rowset = $stmt->fetchAll(‘assoc’);
$result=$rowset;
} while($stmt->nextRowset());
}
catch(Exception $e){}
After execution of this code block, I m getting error as
[Cake\Error\FatalErrorException] Call to undefined method Cake\Database\Log\LoggingStatement::nextRowset()
How can I access these multiple query resultsets?