Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Open
abrasat opened this issue Nov 20, 2023 · 0 comments

Comments

@abrasat
Copy link

abrasat commented Nov 20, 2023

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.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Development

No branches or pull requests

1 participant