SQLBindParameter and "Numeric value out of range" for timestamp arrays
Hello.
I have for the last couple of days been struggling with the Oracle ODBC and timestamps. We have a tool for moving data between databases and we're using ODBC to be able to work against multiple databases but so far we've primarily worked against SQL Server. This week we tried to write data to a Oracle database using the Oracle 10 and 11 Instantclient ODBC driver with an array of parameters. This works fine as long as we do not try to write arrays of imestamps since then we receive the error "Numeric value out of range". We have tried changing the precision in SQLBindParameter from 23 to 19 and the scale from 3 to 0 but to no avail. We're using the TIMESTAMP_STRUCT and SQL_C_TIMESTAMP/SQL_TIMESTAMP and it does not matter if the Oracle column type is DATE or TIMESTAMP. It's always the same error message "Numeric value out of range". This works perfect with "SQL Server" and it works against Oracle too if we only write one row at a time but when we're trying to use an array of timestamps then we get problems.
I can not understand what the problem is and I would gladly get some help from someone that has succeeded with this!
/J