[Mono-bugs] [Bug 455739] New: System.Data. OracleClient can no longer read TimeStamp from cursor into DateTime object

bugzilla_noreply at novell.com bugzilla_noreply at novell.com
Tue Dec 2 15:07:49 EST 2008


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: bnc-blr-team-mono at forge.provo.novell.com
        ReportedBy: webservices at landmarkdigital.com
         QAContact: mono-bugs at lists.ximian.com
          Found By: Development



WebServices Group <webservices at landmarkdigital.com> 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.


More information about the mono-bugs mailing list