Problem Note 68981: Using a certain combination of options sometimes causes incorrect results with SAS/ACCESS® Interface to Oracle
 |  |  |  |  |
Invalid results might be returned if you use SAS/ACCESS Interface to Oracle with a certain combination of options.
The following options, when used together in a program, are known to produce invalid results. However, the exact same code with these options can produce the correct results when run repeatedly:
- the LIBNAME statement option CONNECTION=GLOBAL
- the LIBNAME statement option READBUFF= with a value that is greater than 1000
- the LIBNAME statement option DBCOMMIT=1000 (1000 is the default value)
- a series of steps that use implicit and explicit SQL queries to create Oracle tables and that do not use the ORDER BY clause
The only reliable workarounds are to do one or more of the following:
- Remove the CONNECTION=GLOBAL option.
- Use the DBCOMMIT=0 option.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to Oracle | z/OS | 9.43 | 2021.2.6 | 9.4 TS1M6 | Viya |
| Microsoft® Windows® for x64 | 9.43 | 2021.2.6 | 9.4 TS1M6 | Viya | ||
| Microsoft Windows 8 Enterprise 32-bit | 9.43 | 9.4 TS1M6 | ||||
| Microsoft Windows 8 Enterprise x64 | 9.43 | 2021.2.6 | 9.4 TS1M6 | Viya | ||
| Microsoft Windows 8 Pro 32-bit | 9.43 | 9.4 TS1M6 | ||||
| Microsoft Windows 8 Pro x64 | 9.43 | 2021.2.6 | 9.4 TS1M6 | Viya | ||
| Microsoft Windows 8.1 Enterprise 32-bit | 9.43 | 9.4 TS1M6 | ||||
| Microsoft Windows 8.1 Enterprise x64 | 9.43 | 2021.2.6 | 9.4 TS1M6 | Viya | ||
| Microsoft Windows 8.1 Pro 32-bit | 9.43 | 9.4 TS1M6 | ||||
| Microsoft Windows 8.1 Pro x64 | 9.43 | 2021.2.6 | 9.4 TS1M6 | Viya | ||
| Microsoft Windows 10 | 9.43 | 2021.2.6 | 9.4 TS1M6 | Viya | ||
| Microsoft Windows Server 2008 | 9.43 | 9.4 TS1M6 | ||||
| Microsoft Windows Server 2008 R2 | 9.43 | 2021.2.6 | 9.4 TS1M6 | Viya | ||
| Microsoft Windows Server 2008 for x64 | 9.43 | 2021.2.6 | 9.4 TS1M6 | Viya | ||
| Microsoft Windows Server 2012 Datacenter | 9.43 | 2021.2.6 | 9.4 TS1M6 | Viya | ||
| Microsoft Windows Server 2012 R2 Datacenter | 9.43 | 2021.2.6 | 9.4 TS1M6 | Viya | ||
| Microsoft Windows Server 2012 R2 Std | 9.43 | 2021.2.6 | 9.4 TS1M6 | Viya | ||
| Microsoft Windows Server 2012 Std | 9.43 | 2021.2.6 | 9.4 TS1M6 | Viya | ||
| Microsoft Windows Server 2016 | 9.43 | 2021.2.6 | 9.4 TS1M6 | Viya | ||
| Microsoft Windows Server 2019 | 9.43 | 2021.2.6 | 9.4 TS1M6 | Viya | ||
| Windows 7 Enterprise 32 bit | 9.43 | 9.4 TS1M6 | ||||
| Windows 7 Enterprise x64 | 9.43 | 2021.2.6 | 9.4 TS1M6 | Viya | ||
| Windows 7 Home Premium 32 bit | 9.43 | 9.4 TS1M6 | ||||
| Windows 7 Home Premium x64 | 9.43 | 2021.2.6 | 9.4 TS1M6 | Viya | ||
| Windows 7 Professional 32 bit | 9.43 | 9.4 TS1M6 | ||||
| Windows 7 Professional x64 | 9.43 | 2021.2.6 | 9.4 TS1M6 | Viya | ||
| Windows 7 Ultimate 32 bit | 9.43 | 9.4 TS1M6 | ||||
| Windows 7 Ultimate x64 | 9.43 | 2021.2.6 | 9.4 TS1M6 | Viya | ||
| 64-bit Enabled AIX | 9.43 | 2021.2.6 | 9.4 TS1M6 | Viya | ||
| 64-bit Enabled Solaris | 9.43 | 2021.2.6 | 9.4 TS1M6 | Viya | ||
| HP-UX IPF | 9.43 | 2021.2.6 | 9.4 TS1M6 | Viya | ||
| Linux for x64 | 9.43 | 2021.2.6 | 9.4 TS1M6 | Viya | ||
| Solaris for x64 | 9.43 | 2021.2.6 | 9.4 TS1M6 | Viya | ||
A fix for this issue for SAS/ACCESS Interface to Oracle 9.43 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/E7L.html#68981
SAS/ACCESS Interface to Oracle might produce data integrity issues when using certain LIBNAME statements and the CONNECTION=GLOBAL option.
| Type: | Problem Note |
| Priority: | high |
| Topic: | Data Management ==> Data Sources ==> External Databases ==> Oracle SAS Reference ==> LIBNAME Engines |
| Date Modified: | 2022-05-18 14:14:36 |
| Date Created: | 2022-03-07 04:58:59 |