Got ORA-22835 exception during SaveChanges

rstefan · Post by **rstefan** » Fri 06 Nov 2009 14:55

I get ORA-22835 exception when I'm trying to store an entity object of my model with a binary field.
If the array of bytes that I set to the binary field is to big, I get this error.
I try differents Max Lengths facets for this field but it doesn't change anything.
Here is the exception :

Code: Select all

[OracleException (0x80004005): ORA-22835: Taille de tampon insuffisante pour la conversion de CLOB en CHAR ou de BLOB en RAW (réelle : 3284, maximum : 2000)]
   Devart.Data.Oracle.an.b(Int32 A_0) +283
   Devart.Data.Oracle.ap.e(Int32 A_0) +47
   Devart.Data.Oracle.ap.a(Int32 A_0, a5 A_1) +1058
   Devart.Data.Oracle.OracleCommand.InternalExecute(CommandBehavior behavior, IDisposable disposable, Int32 startRecord, Int32 maxRecords) +4115
   Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior) +749
   System.Data.Common.DbCommand.ExecuteReader() +12
   Devart.Data.Oracle.OracleCommand.ExecuteNonQuery() +64
   Devart.Data.Oracle.Entity.a.m() +104
   System.Data.Mapping.Update.Internal.DynamicUpdateCommand.Execute(UpdateTranslator translator, EntityConnection connection, Dictionary`2 identifierValues, List`1 generatedValues) +554
   System.Data.Mapping.Update.Internal.UpdateTranslator.Update(IEntityStateManager stateManager, IEntityAdapter adapter) +281

Here the SQL request got in DBMonitor :

Code: Select all

 update INFOS
set FNOTE = :p0
where (((FPATID = :p1) and (FITEMKEY = :p2)) and (FINSTANCE = :p3))

the p0 parameter has Blob datatype in DBMonitor and is LONG RAW column in database schema.

How can I store bigger data than 2000 bytes ?

AndreyR · Post by **AndreyR** » Wed 11 Nov 2009 08:19

This problem is fixed in the upcoming build of dotConnect for Oracle.

rstefan · Post by **rstefan** » Thu 12 Nov 2009 06:35

AndreyR wrote:This problem is fixed in the upcoming build of dotConnect for Oracle.

Can you tell me when does the next build will be available ?
My company have to package and deliver the application that has this problem to my customers before the 23th november.
Can we expect it before this date ?

Thank you for your previous reactive answer and support.

AndreyR · Post by **AndreyR** » Thu 12 Nov 2009 13:27

We plan to release the new build next week.