Devart Forums

Hello,

If you run a simple INSERT statement on AIX via Devart.Data.Oracle.OracleCommand.ExecuteNonQuery, a parameter of type OracleDate with a value passed as DateTime is not transferred to the server properly. The Year is not BinaryFormatted property. In particular, while the lower 8 bits of the year is passed correctly, the upper 8 bits of the yeare seems to be scrambled by the value of the lower 8 bits. This looks very much like a LittleEndian/BigEndian problem. AIX is a BigEngian-Machine while x86/AMD64 machines are LittleEndian.

You can download a test application here. If this one is executed on an AIX machine (and most likely all other LittleEndian machines) you should be able to reproduce the error.

Unfortunately, this is a quite urgent problem. Do you have a quick , or any, solution for this?

EDIT: We not only have this problem with the DATE datatype but a similar one with the NUMBER datatype as well. I think the problem has the same case.

Greetings - Richie

We are investigating the situation. We will notify you about the results.

Please specify, which version of dotConnect for Oracle you are using. A similar issue was fixed in the 5.25.49 build.

Hi,
We tested it with 5.35.79.0, and the error still exists.
best regards,
Tobi

Hi,

I experienced similar problems with another component running on a big endian machine and dealing with byte wise encoding of native data formats (FlexCel).

They used the System.BitConverter class, which encodes and decodes multi byte data types with the endianess of the particular platform. This is not desired behavior, if you deal with platform independent native data types. Maybe this is the problem here as well?

Greetings - Richie

We have fixed the problem, look forward to the nearest build.

The new 5.55.97 Beta build of dotConnect for Oracle is available now. It can be downloaded from
http://www.devart.com/dotconnect/oracle/download.html
(trial version) or from Registered Users' Area (for users with active subscription only). For more information, please refer to
http://www.devart.com/forums/viewtopic.php?t=17143

Please inform us whether the problem is completely resolved by this fix.