def rows_as_dicts(cursor):
    """ returns cx_Oracle rows as dicts """
colnames = [i[0] for i in cursor.description]
for row in cursor:
    yield dict(zip(colnames, row))
Making a Dictionary List with cx_Oracle