Page 1 of 1

ORA-22835

Posted: Tue 12 Apr 2016 17:18
by mamax
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)"}

Re: ORA-22835

Posted: Wed 13 Apr 2016 07:24
by Shalex
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.

Re: ORA-22835

Posted: Wed 13 Apr 2016 19:39
by mamax
According to the recomendations, we altered the LONG RAW column to BLOB which solved the problem.
Thank you.