oracle 长查询无返回,cx_Oracle查询返回零行

为什么下面的代码不起作用？它返回零行，即使我有多个匹配的搜索条件。

表单select * from Table_1的简单查询可以正常工作并返回正数行import cx_Oracle

def function_A (data):

connection = cx_Oracle.connect('omitted details here')

for index in range(len(data)):

# connection is already open

cursor = connection.cursor()

query = "select * from Table_1 where column_1=:column1 and column_2=:column2 and column_3=:column3 and column_4=:column4"

bindVars={'column1':data[index][3], 'column2':data[index][4], 'column4':data[index][5], 'column5':data[index][6]}

cursor.execute(query, bindVars)

cursor.arraysize = 256

rowCount = 0

resultSet = cursor.fetchall()

if (resultSet != None):

logger.debug("Obtained a resultSet with length = %s", len(resultSet))

for index in range(len(resultSet)):

logger.debug("Fetched one row from cursor, incrementing counter !!")

rowCount = rowCount + 1

logger.debug("Fetched one row from cursor, incremented counter !!")

logger.debug("Successfully executed the select statement for table Table_1; that returned %s rows !!", rowCount)

logger.debug("Successfully executed the select statement for table Table_1; that returned %s rows !!", cursor.rowcount)

请忽略一些小的格式化问题，代码运行只是没有给我正数行。

代码使用python2.6和兼容版本的cx_Oracle在IBM AIX上运行。