We are moving our forum in GitHub Discussions. For questions about Phalcon v3/v4 you can visit here and for Phalcon v5 here.

handle multiple result sets from procedure

I could not find a way to get more than one result set from calling stored procedure.

I have a stored procedure which will return 2 result sets (2 select statement) and i can get only the first result set from fetchAll().

Is there any way to get the second result set?


just foound a way to my question

        $result = $this->db->query("CALL procedure_name($param)");