I ran some tests and the result, I believe is a bug in the MS Data Provider
for Oracle.
I can create a DateTime object using the string e.g
04/22/2003 10:00:00 AM
I can insert this directly into the Oracle database using a type using the
OracleType enumeration
cmd.Parameters.Add("p_event_date", scheduleEventActionDate);
cmd.Parameters[4].OracleType = OracleType.DateTime;
The insert is successful.
However, if I create a valid datetime with a military/24 hour time string
e.g. 06/25/2003 21:00:00
using the ParseExact method with MM/dd/yyyy HH:mm:ss format specified the
parse throws no error (i.e. it's a valid datetime)
When I try to insert this datetime the connection hangs indefinetly.
I assume all datetimes created by any other than the first method described
will need to be inserted as VARCHAR2 types.
===================================
This list is hosted by DevelopMentor� http://www.develop.com
NEW! ASP.NET courses you may be interested in:
2 Days of ASP.NET, 29 Sept 2003, in Redmond
http://www.develop.com/courses/2daspdotnet
Guerrilla ASP.NET, 13 Oct 2003, in Boston
http://www.develop.com/courses/gaspdotnet
View archives and manage your subscription(s) at http://discuss.develop.com