Pyodbc error upon calling a stored procedure that has ROWSPEC column or more as %Date or %Time
Pyodbc supports calling stored procedure , but if the IRIS Stored Procedure ROWSPEC has a column with datatype specified as %Date or %Time, Pyodbc fails to fetch it and throws this error.
pyodbc.Error: (' 2201', '[ 2201] [Cache ODBC][State : 22018 ][Native Code 22005]\r\nERROR #388: Unknown error, code 22005 (22005) (SQLGetData)')
on printing the cursor execute description, pyodbc reads the column as <int>.
and if the ROWSPEC datatype specification was removed, it fetches successfully.
i'm using the driver "InterSystems IRIS ODBC35" 2019.2.0.107