'test iterators (with intermediate execute)'

def testIteratorsInterrupted(self):

    self.cursor.execute('truncate    table    TestExecuteMany')
    self.cursor.execute('\n                                                                select    IntCol\n                                                                from    TestNumbers\n                                                                where    IntCol    between    1    and    3\n                                                                order    by    IntCol')
    testIter = iter(self.cursor)
    if (sys.version_info[0] >= 3):
        (value,) = next(testIter)
    else:
        (value,) = testIter.next()
    self.cursor.execute('insert    into    TestExecuteMany    (IntCol)    values    (1)')
    if (sys.version_info[0] >= 3):
        self.failUnlessRaises(cx_Oracle.InterfaceError, next, testIter)
    else:
        self.failUnlessRaises(cx_Oracle.InterfaceError, testIter.next)
