'test binding in a string array'

def testBindStringArrayDirect(self):

    returnValue = self.cursor.var(cx_Oracle.NUMBER)
    array = [r[1] for r in self.rawData]
    statement = '\n                                                                begin\n                                                                        :returnValue    :=    pkg_TestStringArrays.TestInArrays(\n                                                                                        :integerValue,    :array);\n                                                                end;'
    self.cursor.execute(statement, returnValue=returnValue, integerValue=5, array=array)
    self.failUnlessEqual(returnValue.getvalue(), 86)
    array = [('String    -    %d' % i) for i in range(15)]
    self.cursor.execute(statement, integerValue=8, array=array)
    self.failUnlessEqual(returnValue.getvalue(), 163)
