Devart Forums

I am using Oracle dotConnect

I am trying to change the column data-type from CLOB to NVARCHAR2 inside the Entity Developer.

When I attempt to update the database from model, I get this error:
The SQL code which was being ran was:
Adding through the Database Explorer tools work.

What is wrong?

PS. Why doesn't the tool add a default length for VARCHAR / NVARCHAR?

Thank you for the report, I have reproduced the error.
I will let you know about the results of our investigation.

AndreyR wrote:Thank you for the report, I have reproduced the error.
I will let you know about the results of our investigation.

Thanks for looking into it.

Are there any walkabout for converting CLOB fields to VARCHAR2 fields? Most of the fields created in Entity Developer (using Entity-First) defaults to the CLOB type for strings and booleans.

The temporary solution is to specify MaxLength for the converted columns.

AndreyR wrote:The temporary solution is to specify MaxLength for the converted columns.

I am unable to edit the SQL for the operations. How do I specify the MaxLength?

Edit: I've found it, inside the Model Explorer, under table store, find the table and right-click the column name and select properties. Hopefully this helps. Or just make sure the property window is open.

Thanks for the help!

You have found the correct way to set the column type.

We have fixed the error. The fixed build will be available in a week or so.

We have released the new 6.30.160 build of dotConnect for Oracle. This build can be dowloaded from here (the trial version) or from Registered Users' Area (for users with active subscription only).
For the detailed information about the improvements and fixes available in dotConnect for Oracle 6.30.160, please refer to this announcement.