Page 1 of 1

ORA-24813: cannot send or receive an unsupported LOB

Posted: Tue 12 Apr 2022 11:53
by Hartraft
Hi All,

After completing an upgrade of Visual Studio 2019 to 16.11.11 and upgrading DotConnect for Oracle to the latest version (9.16) I am now getting the following error when trying to save data in one of our applications.

ORA-24813: cannot send or receive an unsupported LOB

Previously working fine. I believe the issue is related to tables that contain a BLOB column type, as I tested some saving with some simple tables without a BLOB.

Google seems to indicate that the issue is due to Oracle Client/Server being old. We are using 19c for our database and we use Direct Mode in the connection to avoid needing Oracle Client.

Any ideas?

Thanks

Re: ORA-24813: cannot send or receive an unsupported LOB

Posted: Wed 13 Apr 2022 04:08
by Hartraft
Hi All,

An update on this, reverting back to the previously working version of Devart (9.14.1312) has fixed the issue.

For whatever reason there is some type of incompatibility when we go to the latest version.

Thanks

Re: ORA-24813: cannot send or receive an unsupported LOB

Posted: Mon 02 May 2022 06:39
by DmitryGm
To understand what the problem is, we need more information. Please provide us with the completed test project as well as DDL and data for the necessary database tables so that we can reproduce the issue.