[Mono-bugs] [Bug 350407] New: Retrieving a BLOB from a stored proc fails with Object reference not set to an instance of an object

bugzilla_noreply at novell.com bugzilla_noreply at novell.com
Fri Dec 21 14:02:20 EST 2007


https://bugzilla.novell.com/show_bug.cgi?id=350407


           Summary: Retrieving a BLOB from a stored proc fails with Object
                    reference not set to an instance of an object
           Product: Mono: Class Libraries
           Version: 1.2.5
          Platform: i386
        OS/Version: RHEL 5
            Status: NEW
          Severity: Major
          Priority: P5 - None
         Component: Sys.Data
        AssignedTo: bnc-blr-team-mono at forge.provo.novell.com
        ReportedBy: don_dischner at cable.comcast.com
         QAContact: mono-bugs at ximian.com
          Found By: Other


Using System.Data.OracleClient with Oracle 10g on RH5.
I can retrieve a BLOB from a table using ExecuteReader and a sql select string,
but cannot retrieve the blob from a stored proc.
The sql being executed in both cases is "select info1 from asset" where info1
is defined as a BLOB.
// ExecuteReader Code
  OracleCommand rcmd = _connection().CreateCommand();
  rcmd.CommandText = "SELECT info1 from asset";
  OracleDataReader reader2 = rcmd.ExecuteReader();
  if (!reader2.Read())
  {
    OracleLob lob2 = reader2.GetOracleLob(0);
}


-- 
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