.Net Core 5 ORA-00920 Error

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
sdemir
Posts: 4
Joined: Tue 07 Jan 2020 06:41

.Net Core 5 ORA-00920 Error

Post by sdemir » Fri 12 Mar 2021 13:18

Hi,
Using
<TargetFramework>net5.0</TargetFramework>
<PackageReference Include="Devart.Data.Oracle.EFCore" Version="9.14.1204" />

Code: Select all

  var oneDayAgo = DateTime.Now.AddDays(-1);
  var roomQuery = _roomRepository.GetAll()
                         .Where(r => 
                         r.PublishEndDate.HasValue ? r.PublishEndDate >= DateTime.Now : r.CreationTime >= oneDayAgo);
Exception:
Devart.Data.Oracle.OracleException (0x80004005): ORA-00920: invalid relational operator - geçersiz ilişkisel işleç
at Devart.Data.Oracle.cp.b(Int32 A_0)
at Devart.Data.Oracle.ds.c(Int32 A_0)
at Devart.Data.Oracle.ds.a(Int32 A_0, bx A_1)
at Devart.Data.Oracle.OracleCommand.InternalExecute(CommandBehavior behavior, IDisposable disposable, Int32 startRecord, Int32 maxRecords, Boolean nonQuery)
at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior, Boolean nonQuery)
at Devart.Data.Oracle.Entity.ao.a(CommandBehavior A_0)
at Devart.Common.Entity.cw.d(CommandBehavior A_0)
at Devart.Data.Oracle.Entity.ao.b(CommandBehavior A_0)
at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReader(RelationalCommandParameterObject parameterObject)
at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.Enumerator.InitializeReader(DbContext _, Boolean result)
at Microsoft.EntityFrameworkCore.Storage.NonRetryingExecutionStrategy.Execute[TState,TResult](TState state, Func`3 operation, Func`3 verifySucceeded)
at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.Enumerator.MoveNext()
at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
at Go.LiveStream.LiveStreamManager.GetLiveRoomListAsync(Int64 userId) in C:\Git\KC.Uygulamalar\GoAPI\src\Go.Core\LiveStream\LiveStreamManager.cs:line 90
at Go.LiveStream.LiveStreamAppService.GetLiveRoomList() in C:\Git\KC.Uygulamalar\GoAPI\src\Go.Application\LiveStream\LiveStreamAppService.cs:line 94
at Abp.Authorization.AuthorizationInterceptor.InternalInterceptAsynchronous[TResult](IInvocation invocation)
at Abp.Domain.Uow.UnitOfWorkInterceptor.InternalInterceptAsynchronous[TResult](IInvocation invocation)
at Abp.Domain.Uow.UnitOfWorkInterceptor.InternalInterceptAsynchronous[TResult](IInvocation invocation)
at Abp.Auditing.AuditingInterceptor.InternalInterceptAsynchronous[TResult](IInvocation invocation)
at Abp.Runtime.Validation.Interception.ValidationInterceptor.InternalInterceptAsynchronous[TResult](IInvocation invocation)
at lambda_method3724(Closure , Object )
at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.AwaitableObjectResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments)
at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeActionMethodAsync>g__Logged|12_1(ControllerActionInvoker invoker)
at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeNextActionFilterAsync>g__Awaited|10_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)
at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context)
at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeInnerFilterAsync()
--- End of stack trace from previous location ---
at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeNextExceptionFilterAsync>g__Awaited|25_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: .Net Core 5 ORA-00920 Error

Post by Shalex » Sat 13 Mar 2021 13:51

Thank you for your report. We have reproduced the issue and will notify you when it is fixed.

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: .Net Core 5 ORA-00920 Error

Post by Shalex » Sat 03 Apr 2021 13:55

The bug with throwing ORA-00920, when using conditional operator within LINQ query, in EF Core 3 and EF Core 5 is fixed in dotConnect for Oracle v9.14.1228: https://forums.devart.com/viewtopic.php?f=1&t=44776.

Post Reply