Export (0) Print
Expand All

OracleLob.Value Property

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

Namespace:  System.Data.OracleClient
Assembly:  System.Data.OracleClient (in System.Data.OracleClient.dll)

public function get Value () : Object

Property Value

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

ExceptionCondition
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 data type. For null data, Value returns DBNull. By comparing the returned values, you can distinguish among empty data, null data, and data.

NoteNote:

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.

Windows 7, Windows Vista, Windows XP SP2, Windows XP Media Center Edition, Windows XP Professional x64 Edition, Windows XP Starter Edition, Windows Server 2008 R2, Windows Server 2008, Windows Server 2003, Windows Server 2000 SP4, Windows Millennium Edition, Windows 98

The .NET Framework and .NET Compact Framework do not support all versions of every platform. For a list of the supported versions, see .NET Framework System Requirements.

.NET Framework

Supported in: 3.5, 3.0, 2.0, 1.1

Community Additions

ADD
Show:
© 2014 Microsoft