Changing column from CLOB to NVARCHAR2 results in error

extrakun · Post by **extrakun** » Wed 20 Apr 2011 12:42

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:

Code: Select all

ORA-00906: missing left parenthesis

The SQL code which was being ran was:

Code: Select all

ALTER TABLE ITEWORLD."Module"
   ADD (
      "ITEModuleID" NVARCHAR2 NOT NULL
   );

Adding through the Database Explorer tools work.

What is wrong?

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

AndreyR · Post by **AndreyR** » Wed 20 Apr 2011 13:58

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

extrakun · Post by **extrakun** » Wed 20 Apr 2011 14:01

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.

AndreyR · Post by **AndreyR** » Wed 20 Apr 2011 14:45

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

extrakun · Post by **extrakun** » Thu 21 Apr 2011 04:45

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!

AndreyR · Post by **AndreyR** » Thu 21 Apr 2011 10:25

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

AndreyR · Post by **AndreyR** » Tue 10 May 2011 15:02

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

AndreyR · Post by **AndreyR** » Thu 19 May 2011 13:12

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.