Clever Geek Handbook

Getting ORA-00932: Inconsistent data types: expected - got CLOB with First in.net database

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

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

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

There has been a lot of searching and no one mentions this error in a .net context. Hopefully someone might have an idea.

+1


source to share


1 answer


So I decided to solve this. I was using Odp.net version 11. Apparently this is a bug with some linq statements using extension method. I updated odp.net version 12 and fixed the problem.



+1


source






More articles:


All Articles