linq2db.EntityFrameworkCore icon indicating copy to clipboard operation
linq2db.EntityFrameworkCore copied to clipboard

"ORA-01704 string literal too long" exception generated when trying to "upsert" BLOB type column in Oracle

Open abrasat opened this issue 1 year ago • 0 comments

My application uses the InsertWhenNotMatched/UpdateWhenMatched combination to insert or update a BLOB type column in a Oracle. When the blob size exceeds 4000 bytes, the exception "ORA-01704 string literal too long" is thrown. It looks that Linq2Db tries to insert blob as char array (it is declared as byte array in the c# class mapping the Oracle table). If I use directly EF Core with Add and SaveChanges methods to insert for instance a record, the BLOB column is written correctly, even if the byte array has the size greater than 4000.

abrasat avatar Nov 20 '23 13:11 abrasat