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

A fix for this issue for SAS/ACCESS Interface to Oracle 9.42 is available at: