Devart Forums

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.

Thank you for your report. We have reproduced the issue and will notify you when it is fixed.

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.

As a temporary workaround, please use instead of

Thanks! We confirmate that the Workaround is working. Please notify us, when the fix is done.

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.