Export (0) Print
Expand All

OracleLob.Value Property

Note: This namespace, class, or member is supported only in version 1.1 of the .NET Framework.

Gets the common language runtime stream value equivalent of the underlying value.

[Visual Basic]
Public ReadOnly Property Value As Object
public object Value {get;}
public: __property Object* get_Value();
public function get Value() : Object;

Property Value

For Blob, an array of type Byte[]. For Clob and NClob, a String. For null data, DBNull.


Exception Type Condition
ObjectDisposedException The object was closed or disposed.
OracleException An Oracle error has occurred.


For Blob data types, Value returns the entire underlying data as a contiguous array of type Byte[]. For Clob and NClob data types, Value returns all the data as a String. For null data, Value returns DBNull. By comparing the returned values, you can distinguish among empty data, null data, and data.

Note   A benefit of using LOB data types is the capability to retrieve large amounts of data in chunks at the client. However, when you use Value, you obtain all the data for the LOB column as one contiguous chunk, which can significantly increase application overhead.


Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family

.NET Framework Security: 

See Also

OracleLob Class | OracleLob Members | System.Data.OracleClient Namespace

© 2014 Microsoft