'Doctrine PHP - Get multiple table data by calling stored procedure

I would like to get 2 table data from doctrine PHP by calling Stored Procedure.

Getting 2 table data from stored procedure is my business logic.

MYSQL Procedure:

DELIMITER $$
USE `test`$$
DROP PROCEDURE IF EXISTS `pr_test`$$

CREATE DEFINER=`root`@`%` PROCEDURE `pr_test`()
BEGIN

SELECT UUID() AS `uuid`;

SELECT "Large Data Set";
        
END$$

DELIMITER ;

PHP Code:

$stmt = $em->getConnection()->prepare("CALL pr_test()");
$stmt->execute();
$data = $stmt->fetchAll();

I am able to get only the data set. couldn't able to get the second table.

I have checked the documentation, and there is the method called - nextRowSet() but it was removed in new doctrine versions.

Is there any way that I can achieve multiple table rowsets?



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source