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.
ORA-00910 for EF Code First Migrations with Oracle 12
Re: ORA-00910 for EF Code First Migrations with Oracle 12
Thank you for your report. We have reproduced the issue and will notify you when it is fixed.
Re: ORA-00910 for EF Code First Migrations with Oracle 12
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.
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.
Re: ORA-00910 for EF Code First Migrations with Oracle 12
As a temporary workaround, please use
instead of
Code: Select all
CreateTable("A_Table_Name ", c => new { ..., Myfield = c.String(nullable: false; storeType: "clob"), ... })...
Code: Select all
CreateTable("A_Table_Name ", c => new { ..., Myfield = c.String(nullable: false; maxLength: 6000), ... })...
Re: ORA-00910 for EF Code First Migrations with Oracle 12
Thanks! We confirmate that the Workaround is working. Please notify us, when the fix is done.
Re: ORA-00910 for EF Code First Migrations with Oracle 12
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.