This is a great question. If you have access to a MySQL database, please go ahead and test this and share your results with us, perhaps in the form of a reply to Multiple data sets in MySQL stored procedures.

The sample stored procedure in that node would work fine with your fetchall_arrayref investigation.