ORA-00910 for EF Code First Migrations with Oracle 12

ORA-00910 for EF Code First Migrations with Oracle 12

Postby StefanAim » Mon 23 Nov 2015 12:23

We have probles with our existing product switching from Oracle 11 to Oracle 12:
The CodeFirst Migrations don't work anymore for following statement:

CreateTable("A_Table_Name ", c => new { ..., Myfield = c.String(nullable: false; maxLength: 6000), ... })...

For Oracle 11, dotConnect translated this into a CLOB field, with Oracle 12 it creates an
varchar2(6000) which results obviously in an ORA-00910 (length too large for data type) exception

We have OracleMaxStringSize.Standard set and we are using DevArt Version 8.5.464
Comment: We and our customers use standard Oracle settings.
StefanAim
 
Posts: 9
Joined: Mon 02 Sep 2013 14:01

Re: ORA-00910 for EF Code First Migrations with Oracle 12

Postby Shalex » Tue 24 Nov 2015 10:09

Thank you for your report. We have reproduced the issue and will notify you when it is fixed.
Shalex
Devart Team
 
Posts: 7703
Joined: Thu 14 Aug 2008 12:44

Re: ORA-00910 for EF Code First Migrations with Oracle 12

Postby StefanAim » Thu 26 Nov 2015 12:59

Hy,

do you know when you can provide a fix? We are currently finalizing our release (two weeks to go) and we
have to know if we should wait and add a new devart version or have to think about a workaround.
StefanAim
 
Posts: 9
Joined: Mon 02 Sep 2013 14:01

Re: ORA-00910 for EF Code First Migrations with Oracle 12

Postby Shalex » Fri 27 Nov 2015 16:25

As a temporary workaround, please use
Code: Select all
CreateTable("A_Table_Name ", c => new { ..., Myfield = c.String(nullable: false; storeType: "clob"), ... })...

instead of
Code: Select all
CreateTable("A_Table_Name ", c => new { ..., Myfield = c.String(nullable: false; maxLength: 6000), ... })...
Shalex
Devart Team
 
Posts: 7703
Joined: Thu 14 Aug 2008 12:44

Re: ORA-00910 for EF Code First Migrations with Oracle 12

Postby StefanAim » Mon 30 Nov 2015 11:18

Thanks! We confirmate that the Workaround is working. Please notify us, when the fix is done.
StefanAim
 
Posts: 9
Joined: Mon 02 Sep 2013 14:01

Re: ORA-00910 for EF Code First Migrations with Oracle 12

Postby Shalex » Thu 07 Jul 2016 17:30

The bug with generating size of the VARCHAR2 and NVARCHAR2 columns in Oracle 12c using the Code-First/Code-First Migrations functionality is fixed in the newest (9.1.55) build of dotConnect for Oracle.
Shalex
Devart Team
 
Posts: 7703
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for Oracle