Cannot enter GUID via Data Window

Cannot enter GUID via Data Window

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

Re: Cannot enter GUID via Data Window

Postby 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.
Shalex
Devart Team
 
Posts: 7884
Joined: Thu 14 Aug 2008 12:44

Re: Cannot enter GUID via Data Window

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

Postby .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.
.jp
Devart Team
 
Posts: 303
Joined: Wed 09 Sep 2009 06:55
Location: devart

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

Postby 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
Devart
Devart Team
 
Posts: 3152
Joined: Tue 26 Oct 2004 13:51


Return to dbForge for Oracle