OracleLob.Value Property
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Gets the common language runtime stream value equivalent of the underlying value.
public:
property System::Object ^ Value { System::Object ^ get(); };public object Value { get; }member this.Value : objPublic ReadOnly Property Value As ObjectProperty Value
For Blob, an array of type Byte[]. For Clob and NClob, a String. For null data, DBNull.
Exceptions
The object was closed or disposed.
An Oracle error has occurred.
Remarks
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.
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.
