SUPPORT / SAMPLES & SAS NOTES
Problem Note 70293: Inserting data to Oracle with SAS/ACCESS® Interface to ODBC results in garbage data being inserted
 |  |  |  |  |
When inserting data from SAS into Oracle using SAS/ACCESS Interface to Oracle, garbage data might be inserted.
For example, if you insert 4000119375, the data is displayed as 4 0 0 0 1 1 9 3 7 5.
Note: If you view the data in SAS® Studio, there are black diamonds between each number.
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 ODBC | Solaris for x64 | 9.4 TS1M7 | |||
| Linux for x64 | 9.4 TS1M7 | |||||
| HP-UX IPF | 9.4 TS1M7 | |||||
| 64-bit Enabled Solaris | 9.4 TS1M7 | |||||
| 64-bit Enabled AIX | 9.4 TS1M7 | |||||
| SAS System | SAS/ACCESS Interface to ODBC (on SAS Viya) | Linux for x64 | V.03.05 | Stable 2023.05 | Viya | Viya platform |