Devart Forums

I'm getting the following error when I have DateTimeOffset column that maps to Oracle timestamp with time zone column.

ArgumentOutOfRangeException: Offset must be within plus or minus 14 hours. Parameter name: offset

Error occurs while trying to materialize the result.

Error occurs in Direct mode only! In non-direct mode, everything works just fine, but when I switch to direct mode, I get the exception on the same code that worked before.

Some information

Oracle server: 12.1
DevArt component v9.6.540
.NET Core 2.1
EF Core 2.1.1

This is blocking our application to run on Linux since only Direct mode is available on Linux. DevArt, please fix this issue as soon as possible. In OCI mode, I can materialize DateTimeOffset just fine, but in direct mode, it fails to materialize DateTimeOffset when column is mapped to timestamp with time zone column.

Oracle server: 12.1
DevArt component v9.6.540
.NET Core 2.1
EF Core 2.1.1

The bug with using the OracleDbType.TimeStampTZ parameter when working with Oracle 12.1 in the Direct mode is fixed in v9.6.540. Make sure that this is your current version.

If this doesn't help, upload a simple test project with the corresponding DDL/DML script for reproducing to ftp://ftp.devart.com (credentials: anonymous / yourEmail)

I just uploaded sample project (TestOracleProject.zip).

Thanks.

Thank you for your test project. We will notify you when the issue is fixed.

The bug with retrieving TIMESTAMP WITH TIMEZONE values with negative timezone in the Direct mode is fixed: viewtopic.php?f=1&t=37474.