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
Unable to map .NET DateTimeOffset to Oracle timestamp with time zone column
Re: Unable to map .NET DateTimeOffset to Oracle timestamp with time zone column
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
Oracle server: 12.1
DevArt component v9.6.540
.NET Core 2.1
EF Core 2.1.1
Re: Unable to map .NET DateTimeOffset to Oracle timestamp with time zone column
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)
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)
Re: Unable to map .NET DateTimeOffset to Oracle timestamp with time zone column
I just uploaded sample project (TestOracleProject.zip).
Thanks.
Thanks.
Re: Unable to map .NET DateTimeOffset to Oracle timestamp with time zone column
Thank you for your test project. We will notify you when the issue is fixed.
Re: Unable to map .NET DateTimeOffset to Oracle timestamp with time zone column
The bug with retrieving TIMESTAMP WITH TIMEZONE values with negative timezone in the Direct mode is fixed: viewtopic.php?f=1&t=37474.