CODEWITHSUNDEEP
.netvb.netoracle-databaseodp.netora-01858
user38349
user38349

Reputation: 3025

What Date Format Should I Send When Using Oracle.DataAcess

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

Upvotes: 2

Views: 2557

Answers (1)

Vadim K.
Vadim K.

Reputation: 2436

As per Table 3-10 in the Oracle Data Provider for .NET Developer's Guide, the data type of the Value property of the parameter should be System.DateTime (unless you're willing to use an ODP.NET-specific type, in which case it should be OracleDate or one of the OracleTimeStamp types, depending on your column/parameter type).

Upvotes: 2

Related Questions