QUERY RETURNS TRUNCATED VALUE USING ORACLE ODBC DRIVER
(Doc ID 1636799.1)
Last updated on JUNE 21, 2022
Applies to:Oracle ODBC Driver - Version 188.8.131.52 and later
Microsoft Windows (32-bit)
The number fetched from a column contains more zeros then they are truncated using Oracle native ODBC driver.
whereas the values are retrieved correctly when using "Microsoft ODBC Driver for Oracle" for the same query in the same environment.
Truncated column looks similar as below example
1108228 1 200000000005838812000
1108228 1 200000000005838825700
1108228 1 200000000005838843100
1108228 1 5838812000
1108228 1 5838843100
1108228 1 5838825700
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document