Oracle sequence number ODBC problem
Posted on 2002-05-16
I'm trying to get the next sequence number from an Oracle sequence with:
SELECT WRV.WRV_SEQ_ADRESSEN.NEXTVAL FROM DUAL
This works fine with the Oracle ODBC drivers from Oracle, but not with those from microsoft. Miscrosoft gives an "value out of range" error (error 22003) for sequences with high numbers.
I checked the ODBC trace for both drivers and it appears that the Microsft versions see the NEXTVAL column as a SQL_C_SHORT (5 positions) where Oracle sees it as a SQL_C_DOUBLE (8 positions).
Unofrtunately the target machine has only Microsoft ODBC drivers so I'm stuck with those.
How do I tell the Microsoft ODBC driver for Oracle to use a larger datatayp for the NEXTVAL column?
How can I instruct