This instance property returns the data, starting from the first character in the CLOB or NCLOB, as a string.

Declaration

// C#
public string Value{get;}

Property Value

A string.

Exceptions

ObjectDisposedException - The object is already disposed.

InvalidOperationException - The OracleConnection is not open or has been closed during the lifetime of the object.

ArgumentOutOfRangeException - The Value is less than 0.

Remarks

The value of Position is neither used nor changed by using this property.

The maximum string length that can be returned by this property is 2 GB.

For very large values, .NET may not be able to allocate enough contiguous memory to store all the data. Typically, you will see a System.OverflowException or System.OutOfMemoryException error then. To retrieve the large value, you can retrieve the data in chunks by calling GetChars() or GetBytes() method on the OracleDataReader. You can also call Read() method on the class.