Cannot enter GUID via Data Window

[extrakun]

I am trying to enter a GUID into one of the membership provider tables. The tables are created the SQL script provided by dotConnect.

However, when I attempt to enter a GUID, such as "8F34D6F653FA864385091AD5BB5FD5FF", I get the error message :

Code: Select all

ORA-12899: value too large for column
"USER"."ASPNET_ROLES"."ROLEID" (actual : 17, maximum 16)
ORA-06512: at line 1

The definition for the ROLEID column is RAW(16)

Note: The GUID is valid and has only 16 characters

[Shalex]

Cannot enter GUID via Data Window

I have tried to insert your GUID ("8F34D6F653FA864385091AD5BB5FD5FF") into the RAW(16) column via OracleCommand using dotConnect for Oracle v 6.30.160. It works.
Please specify your current version (x.xx.xxx) of dotConnect for Oracle and the steps we should follow to invoke "Data Window". If you are using OraDeveloper Tools, specify its version as well and the version of your Visual Studio.

[extrakun]

Cannot enter GUID via Data Window

I have tried to insert your GUID ("8F34D6F653FA864385091AD5BB5FD5FF") into the RAW(16) column via OracleCommand using dotConnect for Oracle v 6.30.160. It works.
Please specify your current version (x.xx.xxx) of dotConnect for Oracle and the steps we should follow to invoke "Data Window". If you are using OraDeveloper Tools, specify its version as well and the version of your Visual Studio.

Hi sorry, I forgot to specify that this is using the OraDeveloper tool and the dotConnect data window.

[.jp]

Now we are working on the third version of OraDeveloper. And the product will be called dbForge Studio/Tools for Oracle. The problem you described is fixed there. Unfortunately, we cannot fix this problem in the current (2.xx) version. Please wait for the next version.

[extrakun]

Now we are working on the third version of OraDeveloper. And the product will be called dbForge Studio/Tools for Oracle. The problem you described is fixed there. Unfortunately, we cannot fix this problem in the current (2.xx) version. Please wait for the next version.

Thank you. We just bought the licenses for dotConnect Pro recently; will there be a free upgrade?

[Devart]

yes, you will get a free upgrade.
We will send you a notification email on the new version release.

Regards,
Devart Support