70293 - Inserting data to Oracle with SAS/ACCESS® Interface to ODBC results in garbage data being inserted

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.

Product Family	Product	System	Product Release		SAS Release
Product Family	Product	System	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

* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.

A fix for this issue for SAS/ACCESS Interface to ODBC 9.4_M8 is available at:

Type:	Problem Note
Priority:	high

Date Modified:	2023-08-18 13:25:22
Date Created:	2023-08-03 11:01:54