We are incurring a problem with the unixODBC Driver via Oracle Heterogeneous Services for connecting from a 64-bit SUSE Linux Server to a Windows PostgreSQL database (8.2). Oracle is 184.108.40.206. We are receiving an error when retrieving SMALLINT data from PostGreSQL. This should "automagically" convert to NUMBER(5) in Oracle but we are receiving a conversion error.
Here is the text of the HS Trace file. Any help in diagnosing this would be much appreciated.
Oracle Corporation --- MONDAY DEC 17 2012 17:14:36.779
Heterogeneous Agent Release
Oracle Corporation --- MONDAY DEC 17 2012 17:14:36.778