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

Reply via email to