Insert fails with Oracle DataAdapter and date colum

[Bent S. Lund]

Hi,

the following parameter fails during insert using the OracleDataAdapter on a
9.2.0.5 server.
da.InsertCommand.Parameters.Add("@time",OracleType.DateTime,10,"time");

Any suggestions to what causes this? The value inserted is of datetime type.



Regards,



Bent

 

[Jon Skeet [C# MVP]]

the following parameter fails during insert using the OracleDataAdapter on a
9.2.0.5 server.
da.InsertCommand.Parameters.Add("@time",OracleType.DateTime,10,"time");

Any suggestions to what causes this? The value inserted is of datetime type.

What kind of failure are you getting? If there's an exception, what
does it say?