"ORA-00936: missing expression" error when using latest Oracle.EntityFrameworkCore 9.23.60 and .net 9.0.1

[tegrit-joe-trupiano]

Does not work on.
Oracle.EntityFrameworkCore 9.23.60
.NET 9.0.1

Worked on.
Oracle.EntityFrameworkCore 8.23.60
.NET 8.0.11

This query worked before moving to latest Oracle.ManagedDataAccess.Client and .net9.

Query in question from Debug view

Code used the generate query

Trace files set to TraceLevel = 7

APPLICATION.EXE_PID_32892_DATE_2025_01_23_TIME_14_16_44_560915.txt

[alexkeh]

Can you share the SQL generated during the Oracle EF Core 8.23.60 run?

What is the difference between the two SELECT statements in Oracle EF Core 9 and 8?

[tegrit-joe-trupiano]

Can you share the SQL generated during the Oracle EF Core 8.23.60 run?

What is the difference between the two SELECT statements in Oracle EF Core 9 and 8?

Before .net 9

After .net 9

[alexkeh]

I filed bug 37518067 to have the Oracle EF Core dev team look into this issue.