Page 1 of 1

ORA-00932: inconsistent datatypes: expected - got NCLOB

Posted: Mon 10 Feb 2014 14:35
by midnit
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.

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

Posted: Tue 11 Feb 2014 14:46
by Shalex
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.