ORA-22835

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
mamax
Posts: 2
Joined: Tue 12 Apr 2016 16:38

ORA-22835

Post by mamax » Tue 12 Apr 2016 17:18

Hi,
I am using dotConnect for Oracle 8.4.225 with EF6 having problems storing to a table with a LONG RAW column.
The entity-side property is of type byte[].
Reading works fine (in the unit test the size of the resulting byte[] is 11.000) but creating and storing it to the Oracle 11 DB brings this error:
{"ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversion (actual: 22868, maximum: 2000)"}

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: ORA-22835

Post by Shalex » Wed 13 Apr 2016 07:24

Please send us a small complete test project with the corresponding DDL/DML script for reproducing. In case of >2MB attachment, we recommend either using some file exchange server (send us the corresponding link) or uploading a test project to our FTP server (the credentials will be provided by email request).

JIC: according to official Oracle recomendations, usage of LONG and LONG RAW data types is not recommended.

mamax
Posts: 2
Joined: Tue 12 Apr 2016 16:38

Re: ORA-22835

Post by mamax » Wed 13 Apr 2016 19:39

According to the recomendations, we altered the LONG RAW column to BLOB which solved the problem.
Thank you.

Post Reply