Movatterモバイル変換

Syntax:

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 thecallproc() 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 usesstored_results() to retrieve them:

>>> cursor.callproc('myproc')()>>> for result in cursor.stored_results():...     print result.fetchall()...[(1,)][(2,)]