Broken Guids saved with Direct=false

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
florin
Posts: 1
Joined: Fri 07 Oct 2016 10:24

Broken Guids saved with Direct=false

Post by florin » Fri 07 Oct 2016 11:33

When inserting Guids into a RAW(16) column using OracleCommand.ExecuteArray, the inserted values are broken if the connection has Direct=false.
If the connection is Direct=true, the inserted values are ok.
The image below shows the values stored in a table for both cases. You can see there are some broken Guid values inserted:

Image

I have also prepared a sample application to reproduce this issue here http://tinyurl.com/jysuk8h

Please provide us with a solution for this issue.
Thanks!

Pinturiccio
Devart Team
Posts: 2420
Joined: Wed 02 Nov 2011 09:44

Re: Broken Guids saved with Direct=false

Post by Pinturiccio » Mon 10 Oct 2016 15:01

We have reproduced the issue. We will investigate it and post here about the results as soon as possible.

Pinturiccio
Devart Team
Posts: 2420
Joined: Wed 02 Nov 2011 09:44

Re: Broken Guids saved with Direct=false

Post by Pinturiccio » Wed 12 Oct 2016 10:38

We have fixed the bug with inserting a collection of Guid when using array binding in the OCI mode if Size is not explicitly set for the corresponding parameters of the OracelDbType.Raw type. We will post here when the corresponding build of dotConnect for Oracle is available for download.

Pinturiccio
Devart Team
Posts: 2420
Joined: Wed 02 Nov 2011 09:44

Re: Broken Guids saved with Direct=false

Post by Pinturiccio » Fri 21 Oct 2016 14:11

New build of dotConnect for Oracle 9.1.131 is available for download!
It can be downloaded from http://www.devart.com/dotconnect/oracle/download.html (trial version) or from Registered Users' Area (for users with valid subscription only).
For more information, please refer to viewtopic.php?t=34458

Post Reply