'test binding in a date array (with arrayvar)'

def testBindDateArrayByVar(self):

    returnValue = self.cursor.var(cx_Oracle.NUMBER)
    array = self.cursor.arrayvar(cx_Oracle.DATETIME, 10, 20)
    array.setvalue(0, [r[1] for r in self.rawData])
    self.cursor.execute('\n                                                                begin\n                                                                        :returnValue    :=    pkg_TestDateArrays.TestInArrays(\n                                                                                        :startValue,    :baseDate,    :array);\n                                                                end;', returnValue=returnValue, startValue=7, baseDate=cx_Oracle.Date(2002, 12, 14), array=array)
    self.failUnlessEqual(returnValue.getvalue(), 17.5)
