Page 1 of 1

Using LINQ to insert/update Oracle Table with CLOB column

Posted: Fri 22 Jul 2011 17:49
by justinsweet
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 -

Posted: Mon 25 Jul 2011 10:22
by StanislavK
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.