Using LINQ to insert/update Oracle Table with CLOB column

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
justinsweet
Posts: 2
Joined: Fri 22 Jul 2011 17:38

Using LINQ to insert/update Oracle Table with CLOB column

Post by justinsweet » Fri 22 Jul 2011 17:49

We are receiving error message when trying to update/insert a table in oracle that has a CLOB column through Linq.

Context.TABLE.InsertOnSubmit(object);
Context.SubmitChanges();

SubmitChanges throws the following error:
ORA-00932: inconsistent datatypes: expected CLOB got -

StanislavK
Devart Team
Posts: 1710
Joined: Thu 03 Dec 2009 10:48

Post by StanislavK » Mon 25 Jul 2011 10:22

Could you please describe the issue in more details? For example, please specify the following:
- the version of dotConnect for Oracle (or LinqConnect) you are using;
- whether you are using the Direct connection mode;
- the .NET type to which the CLOB column is mapped, and the value that is inserted into this column.

Post Reply