Updating DATE or TIMESTAMP fails with Oracle.EntityFrameworkCore 8.23.x and 9.23.x

[jovball]

My workplace is using Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.29.0.0.0. We have been using Oracle.EntityFrameworkCore 8.21.x and Oracle.ManagedDataAccess.Core 3.21.x without any issues. We are starting work on a new major application and upgraded the Nuget packages to 9.23.x and 23.26.x. Using those Nuget packages, any update statement setting a value for a DATE or TIMESTAMP column is failing with ORA-06550, PLS-00382: expression is of wrong type. Backing down to 8.23.x gives the same result.

I have a test project using ASP.NET Core v9. I can attach a git repo if needed.

[alexkeh]

You can try setting UseOracleSQLCompatibility with OracleSQLCompatibility.DatabaseVersion19.

Neither DATE nor TIMESTAMP has changed its DB data type characteristics between 19c and 23ai. However, perhaps there is an internal SQL executed that uses a Boolean that causes this error. An ODP.NET trace would be most useful to diagnose the issue.