Problem Note 62366: A data integrity issue occurs after you query an Oracle view with an Oracle 12.1.0.2 server or a later server version
 |  |  |  |  |
You might observe a data integrity issue in a SAS® program query to an Oracle view.
The issue occurs when all of the following are true:
- The Oracle server is 12.1.0.2 or a later version.
- The SAS query accesses an Oracle view.
- The SAS query contains a WHERE clause regarding a character column in the Oracle view.
- The WHERE clause is an equality comparison (for example, WHERE string = 'value').
- The length of the value is less than the length of the Oracle column.
- PROC SQL is used with Oracle librefs.
No errors or warnings indicate any problem. The only indication is unexpected data returned to SAS. For example, you might expect to see "value" but see "value €Y@" instead.
There are no practical workarounds, but one of the following actions might help:
- Revert to an earlier version of the Oracle server.
- Change the SAS query to use either an explicit Structured Query Language (SQL) pass-through facility or a DATA step.
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.4 | 9.43 | 9.4 TS1M0 | 9.4 TS1M6 |
| Microsoft® Windows® for x64 | 9.4 | 9.43 | 9.4 TS1M0 | 9.4 TS1M6 | ||
| Microsoft Windows 8 Enterprise x64 | 9.4 | 9.43 | 9.4 TS1M0 | 9.4 TS1M6 | ||
| Microsoft Windows 8 Pro x64 | 9.4 | 9.43 | 9.4 TS1M0 | 9.4 TS1M6 | ||
| Microsoft Windows 8.1 Enterprise 32-bit | 9.4 | 9.43 | 9.4 TS1M0 | 9.4 TS1M6 | ||
| Microsoft Windows 8.1 Enterprise x64 | 9.4 | 9.43 | 9.4 TS1M0 | 9.4 TS1M6 | ||
| Microsoft Windows 8.1 Pro 32-bit | 9.4 | 9.43 | 9.4 TS1M0 | 9.4 TS1M6 | ||
| Microsoft Windows 8.1 Pro x64 | 9.4 | 9.43 | 9.4 TS1M0 | 9.4 TS1M6 | ||
| Microsoft Windows 10 | 9.4 | 9.43 | 9.4 TS1M0 | 9.4 TS1M6 | ||
| Microsoft Windows Server 2008 R2 | 9.4 | 9.4 TS1M0 | ||||
| Microsoft Windows Server 2008 for x64 | 9.4 | 9.4 TS1M0 | ||||
| Microsoft Windows Server 2012 Datacenter | 9.4 | 9.43 | 9.4 TS1M0 | 9.4 TS1M6 | ||
| Microsoft Windows Server 2012 R2 Datacenter | 9.4 | 9.43 | 9.4 TS1M0 | 9.4 TS1M6 | ||
| Microsoft Windows Server 2012 R2 Std | 9.4 | 9.43 | 9.4 TS1M0 | 9.4 TS1M6 | ||
| Microsoft Windows Server 2012 Std | 9.4 | 9.43 | 9.4 TS1M0 | 9.4 TS1M6 | ||
| Windows 7 Enterprise x64 | 9.4 | 9.43 | 9.4 TS1M0 | 9.4 TS1M6 | ||
| Windows 7 Professional x64 | 9.4 | 9.43 | 9.4 TS1M0 | 9.4 TS1M6 | ||
| 64-bit Enabled AIX | 9.4 | 9.43 | 9.4 TS1M0 | 9.4 TS1M6 | ||
| 64-bit Enabled Solaris | 9.4 | 9.43 | 9.4 TS1M0 | 9.4 TS1M6 | ||
| HP-UX IPF | 9.4 | 9.43 | 9.4 TS1M0 | 9.4 TS1M6 | ||
| Linux for x64 | 9.4 | 9.43 | 9.4 TS1M0 | 9.4 TS1M6 | ||
| Solaris for x64 | 9.4 | 9.43 | 9.4 TS1M0 | 9.4 TS1M6 | ||
A fix for this issue for SAS/ACCESS Interface to Oracle 9.42 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/C7I.html#62366
Under certain conditions, incorrect data occurs at the ends of character columns when the data is returned from Oracle views.
| Type: | Problem Note |
| Priority: | alert |
| Date Modified: | 2018-07-26 14:58:59 |
| Date Created: | 2018-05-25 10:27:19 |