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:
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!
Broken Guids saved with Direct=false
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: Broken Guids saved with Direct=false
We have reproduced the issue. We will investigate it and post here about the results as soon as possible.
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: Broken Guids saved with Direct=false
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.
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: Broken Guids saved with Direct=false
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
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