What Date Format Should I Send When Using Oracle.DataAcess.
Posted
by discwiz
on Stack Overflow
See other posts from Stack Overflow
or by discwiz
Published on 2010-04-27T20:06:48Z
Indexed on
2010/04/27
20:33 UTC
Read the original article
Hit count: 335
Converting from usind Micorsofts Syste.Data.OracleClient to what I believe is called Oracles ODT (Oracle.DataAccess 10.2.0.100). When I try and send a date I get this error "ORA-1858: a non-numeric character was found where a numeric was expected". This code worked great using System.Data.OracleClient.
cmd.Parameters.Add(New OracleParameter("I_FIRST_LOSS_EVENT_DATE", OracleDbType.Date)).Value = .LossEventsMessages(0).LossEventTime
Thanks,
Dave
© Stack Overflow or respective owner
