Value Property (OracleLob)

In This Topic

Gets the value of the OracleLob object.

Syntax

Visual Basic
C#

'Declaration
 
Public ReadOnly Property Value As Object

public object Value {get;}

Property Value

For OracleDbType.Blob and OracleDbType.BFile, an array of type Byte[]. For OracleDbType.Clob and OracleDbType.NClob, a string. For null data, Null.

Remarks

Check the IsNull property before reading the Value property to avoid raising an exception.

Example

This code fragment downloads a LOB field from a table to a file. Value property is initialized by calling GetOracleLob method and then written to a stream.

csharp

OracleLob myLob = myReader.GetOracleLob(myReader.GetOrdinal("Picture"));
if(!myLob.IsNull)
{
  string FN = myReader.GetString(myReader.GetOrdinal("PicName"));
  FileStream fs = new FileStream("D:\\Tmp\\"+FN+".bmp", FileMode.Create);
  fs.Write(myLob.Value,0,(int)myLob.Length);
  fs.Close();
  Console.WriteLine(FN+" downloaded.");
}

Visual Basic

Dim myLob As OracleLob = myReader.GetOracleLob(myReader.GetOrdinal("Picture"))
If Not myLob.IsNull Then
  Dim FN As String = myReader.GetString(myReader.GetOrdinal("PicName"))
  Dim fs As FileStream = New FileStream("D:\Tmp\" + FN + ".bmp", FileMode.Create)
  fs.Write(myLob.Value, 0, Convert.ToInt32(myLob.Length))
  fs.Close()
  Console.WriteLine(String.Concat(FN, " downloaded."))
End If

Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

Reference

OracleLob Class
OracleLob Members
Read Method
Write Method

Send Feedback