https://bugzilla.novell.com/show_bug.cgi?id=455739
Summary: System.Data.OracleClient can no longer read TimeStamp
from cursor into DateTime object
Product: Mono: Class Libraries
Version: 2.2.x
Platform: x86-64
OS/Version: openSUSE 11.0
Status: NEW
Severity: Critical
Priority: P5 - None
Component: Sys.Data
AssignedTo: [EMAIL PROTECTED]
ReportedBy: [EMAIL PROTECTED]
QAContact: [email protected]
Found By: Development
WebServices Group <[EMAIL PROTECTED]> changed:
What |Removed |Added
----------------------------------------------------------------------------
Flag|
|SHIP_STOPPER?
We ran the following test:
working unit test in Mono 1.9.1 that does the following:
- executes Oracle stored procedure that returns a cursor containing Oracle
TimeStamp values (as well as other fields)
- reads the cursor into a DataTable using a datareader (because
dataadapter.fill doesn't work for oracle in 1.9.1)
after upgrading to Mono 2.2 preview 1, I get the following error:
System.ArgumentOutOfRangeException: Argument is out of range.
Parameter name: Parameters describe an unrepresentable DateTime.
at System.DateTime.ctor(Int32 Year,Int32 month,Int32 day,Int32 hour,Int32
minute, Int32 second, Int32 millisecond)
at System.Data.OracleClient.Oci.OciDateTimeDescriptor.GetDateTime
(System.Data.OracleClient.Oci.OciHandle handle,
System.Data.OracleClient.Oci.OciErrorHandle errorHandle)
piece of code that extracts the datatable from the cursor (that is the out
parameter of the stored procedure):
DataTable dt = new DataTable();
if(Cursor.Value != null)
{
using (OracleDataReader dataReader = (OracleDataReader)(Cursor.Value))
{
dt.Load(dataReader);
}
Console.WriteLine("DataTable Rows:" + dt.Rows.Count.ToString());
}
--
Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the QA contact for the bug.
_______________________________________________
mono-bugs maillist - [email protected]
http://lists.ximian.com/mailman/listinfo/mono-bugs
