What date format should I send when using Oracle.DataAcess
Converting from usind Micorsoft Syste.Data.OracleClient to what I believe is called Oracles ODT (Oracle.DataAccess 10.2.0.100). When I try to send a date, I get this error "ORA-1858: A non-numeric character was found where a number was expected." This code did a great job using System.Data.OracleClient.
cmd.Parameters.Add(New OracleParameter("I_FIRST_LOSS_EVENT_DATE", OracleDbType.Date)).Value = .LossEventsMessages(0).LossEventTime
Thanks,
Dave
a source to share
According to Table 3-10 in Oracle Data Provider for .NET Developer Guide, the data type of the property Value
parameter must be System.DateTime
(if you do not want to use the ODP.NET type, in this case it must be OracleDate
or one of the types OracleTimeStamp
, depending on your column type / parameter).
a source to share