ORA-00932: inconsistent datatypes: expected - got NCLOB

Discussion of open issues, suggestions and bugs regarding Entity Framework support in ADO.NET Data providers
Post Reply
midnit
Posts: 10
Joined: Tue 23 Mar 2010 19:50

ORA-00932: inconsistent datatypes: expected - got NCLOB

Post by midnit » Mon 10 Feb 2014 14:35

Starting with fresh MVC template (VS2013) using EF6.01 and 8.2.90.6 driver. When code first creates the tables its creating with NCLOB where I would expect VARCHAR2. It then errors with the subject. If I change the fields to VARCHAR2 everything works, but how can I get it to stop generating incorrectly? Its defined as string in my migration.

This is all the built in template stuff, I have not written any code - just configured the web.config to use devart.

Shalex
Site Admin
Posts: 8295
Joined: Thu 14 Aug 2008 12:44

Re: ORA-00932: inconsistent datatypes: expected - got NCLOB

Post by Shalex » Tue 11 Feb 2014 14:46

Please use lightweight conventions to make all string properties non-unicode and non-lob: http://blog.devart.com/entity-framework ... NonUnicode. As a result, VARCHAR2(2000) should be generated instead of NCLOB.

Post Reply