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

Reference

OracleLob Class
OracleLob Members
Read Method
Write Method

Send Feedback