Cannot enter GUID via Data Window

Discussion of open issues, suggestions and bugs regarding database management and development tools for Oracle
Post Reply
extrakun
Posts: 22
Joined: Wed 20 Apr 2011 06:02

Cannot enter GUID via Data Window

Post by extrakun » Mon 30 May 2011 08:49

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
Site Admin
Posts: 8248
Joined: Thu 14 Aug 2008 12:44

Re: Cannot enter GUID via Data Window

Post by Shalex » Wed 01 Jun 2011 11:25

extrakun wrote: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
Posts: 22
Joined: Wed 20 Apr 2011 06:02

Re: Cannot enter GUID via Data Window

Post by extrakun » Tue 05 Jul 2011 04:39

Shalex wrote:
extrakun wrote: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
Devart Team
Posts: 307
Joined: Wed 09 Sep 2009 06:55
Location: devart

Post by .jp » Mon 11 Jul 2011 08:40

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
Posts: 22
Joined: Wed 20 Apr 2011 06:02

Post by extrakun » Thu 14 Jul 2011 07:09

.jp wrote: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
Site Admin
Posts: 3280
Joined: Tue 26 Oct 2004 13:51

Post by Devart » Thu 14 Jul 2011 13:55

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

Regards,
Devart Support

Post Reply