OracleType.DateTime

[N.K]

I am calling ORacle Stored Proc which accepts date as one of param ,
in my code

oraCommand.Parameters["start_date"].Value = new DateTime(...,...,..);

but the proc doesnt returns values expected, If i call proc from SQL
plus it returns correct values.

Is .NET DateTime compatible with OracleType.DateTime ???

 

[Brian Henry]

should be converted through the OLE DB connector to the right datatype in
both directrions automaticly.