CODEWITHSUNDEEP
c#.netoracle-databaseentity-framework
g.t.w.d
g.t.w.d

Reputation: 621

Getting ORA-00932: inconsistent datatypes: expected - got CLOB with Database First in .net

So I am using EF database first on an oracle db. I am getting the above error when I do this in my code:

contractType.CLIENT_TYPE != null && contractType.CLIENT_TYPE.ToUpper() == "POL"

That column is defined as VARCHAR2(10 BYTE) in Oracle and the .net type is string.

Did a lot of searching and no one really mentions this error in the context of .net. Hoping someone might have an idea.

Upvotes: 1

Views: 1599

Answers (1)

g.t.w.d
g.t.w.d

Reputation: 621

So I figured out a solution to this. I was using Odp.net version 11. Apparently this is a bug with certain linq statements using the where extension method. I upgraded to odp.net version 12 and it fixed the issue.

Upvotes: 1

Related Questions