66695 - Running PROC DS2 code could fail when an Oracle column in the table contains the CLOB data type

Problem Note 66695: Running PROC DS2 code could fail when an Oracle column in the table contains the CLOB data type

When you run PROC DS2 code with the FEDSVR Engine or the Oracle Engine, the code might fail. This problem occurs when an Oracle table column contains the CLOB data type. When you encounter this issue, an error similar to one of the following might occur:

ERROR: Value for row length cannot be handled by DS2.
ORA-01461: can bind a LONG value only for insert into a LONG column

Click the Hot Fix tab in this note for a link to instructions about accessing and applying the software update.

Operating System and Release Information

Product Family	Product	System	Product Release		SAS Release
			Reported	Fixed*	Reported	Fixed*
SAS System	SAS Data Connector to Oracle	Linux for x64	V.03.05	2020.1.1	Viya	Viya

* 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.

Viya on Linux: An update for this issue is available for SAS Viya 3.5. For instructions on how to access and apply software updates, see the Updating Your SAS Viya software section in the SAS Viya 3.5 for Linux Deployment Guide at

http://documentation.sas.com/?softwareId=administration&softwareVersion=3.5&softwareContextId=softwareUpdates

Type:	Problem Note
Priority:	high

Date Modified:	2020-10-01 12:38:17
Date Created:	2020-09-25 17:57:29

Support

Problem Note 66695: Running PROC DS2 code could fail when an Oracle column in the table contains the CLOB data type

Operating System and Release Information