Oracle.ManagedDataAccess.Core 23.5.1
Oracle.EntityFrameworkCore 8.23.50
Microsoft.EntityFrameworkCore 8.0.8
Database: Oracle 19
EF class
\[Column("LASTACTIVITYDATE", TypeName = "DATE")\]
public DateTime LastActivityDate { get; set; }
Date being set via DateTime.UtcNow (Although Datetime.Now attempted)
Error:
---> Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-06550: line 15, column 10:
PLS-00382: expression is of wrong type
EF debugging says the parameter is this:
DateTime.UtcNow
:p5='2024-08-16T15:40:03.8466907Z' (DbType = Date)
DateTime.Now
:p5='2024-08-16T12:03:26.4111098-04:00' (DbType = Date)
Am I missing something about Oracle 23+ about inserting date values (that aren't defaulted) into the db?