Documentation Home
MySQL Connector/Python Developer Guide
Related Documentation Download this Manual
PDF (US Ltr) - 0.7Mb
PDF (A4) - 0.7Mb

MySQL Connector/Python Developer Guide  /  ...  /  MySQLCursor.stored_results() Method

10.5.13 MySQLCursor.stored_results() Method


iterator = cursor.stored_results()

This method returns a list iterator object that can be used to process result sets produced by a stored procedure executed using the callproc() method. The result sets remain available until you use the cursor to execute another operation or call another stored procedure.

The following example executes a stored procedure that produces two result sets, then uses stored_results() to retrieve them:

>>> cursor.callproc('myproc')
>>> for result in cursor.stored_results():
...     print result.fetchall()