Problem Note 50485: Any attempt to read Oracle tables with certain column data types might return incorrect values
 |  |  |  |  |
Reading any of the following Oracle column data types into a SAS® 9.4 variable might result in the SAS value being incorrect:
- TIMESTAMP
- TIMESTAMP WITH TIME ZONE
- TIMESTAMP WITH LOCAL TIME ZONE
- INTERVAL YEAR TO MONTH
- INTERVAL DAY TO SECONDS
This problem occurs if you downloaded SAS/ACCESS® 9.4 Interface to Oracle on or before July 24, 2013.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Note: No action is necessary if your copy of SAS/ACCESS 9.4 Interface to Oracle is Rev. 940_13w30 or is dated later than July 24, 2013.
Note: If your copy of SAS/ACCESS 9.4 Interface to Oracle is dated later than July 24, 2013, and you are receiving incorrect values, contact Technical Support.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to Oracle | Microsoft® Windows® for x64 | 9.4 | 9.4_M1 | 9.4 TS1M0 | 9.4 TS1M1 |
| Microsoft Windows 8 Enterprise | 9.4 | 9.4_M1 | 9.4 TS1M0 | 9.4 TS1M1 | ||
| Microsoft Windows 8 Pro | 9.4 | 9.4_M1 | 9.4 TS1M0 | 9.4 TS1M1 | ||
| Microsoft Windows Server 2008 R2 for x64 | 9.4 | 9.4_M1 | 9.4 TS1M0 | 9.4 TS1M1 | ||
| Microsoft Windows Server 2008 for x64 | 9.4 | 9.4_M1 | 9.4 TS1M0 | 9.4 TS1M1 | ||
| Microsoft Windows Server 2012 Datacenter | 9.4 | 9.4_M1 | 9.4 TS1M0 | 9.4 TS1M1 | ||
| Microsoft Windows Server 2012 Std | 9.4 | 9.4_M1 | 9.4 TS1M0 | 9.4 TS1M1 | ||
| Windows 7 Enterprise x64 | 9.4 | 9.4_M1 | 9.4 TS1M0 | 9.4 TS1M1 | ||
| Windows 7 Professional x64 | 9.4 | 9.4_M1 | 9.4 TS1M0 | 9.4 TS1M1 | ||
| 64-bit Enabled AIX | 9.4 | 9.4_M1 | 9.4 TS1M0 | 9.4 TS1M1 | ||
| 64-bit Enabled Solaris | 9.4 | 9.4_M1 | 9.4 TS1M0 | 9.4 TS1M1 | ||
| HP-UX IPF | 9.4 | 9.4_M1 | 9.4 TS1M0 | 9.4 TS1M1 | ||
| Linux for x64 | 9.4 | 9.4_M1 | 9.4 TS1M0 | 9.4 TS1M1 | ||
| Solaris for x64 | 9.4 | 9.4_M1 | 9.4 TS1M0 | 9.4 TS1M1 | ||
A fix for this issue for SAS/ACCESS Interface to Oracle 9.4 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/L06.html#50485
Any attempt to read Oracle tables with columns of the data types TIMESTAMP, TIMESTAMP WITH TIME ZONE, TIMESTAMP WITH LOCAL TIME ZONE, INTERVAL YEAR TO MONTH, or INTERVAL DAY TO SECONDS might return incorrect values when you download SAS® 9.4 SAS/ACCESS to Oracle on or before July 24, 2013.
| Type: | Problem Note |
| Priority: | alert |
| Date Modified: | 2013-07-23 16:02:20 |
| Date Created: | 2013-07-23 14:57:12 |