Length Property (OracleLob)

In This Topic

Gets the size of the OracleLob.

Syntax

Visual Basic
C#

'Declaration
 
Public Overrides ReadOnly Property Length As Long

public override long Length {get;}

Property Value

The size of the OracleLob in bytes.

Remarks

The size of the OracleLob is always returned in bytes for all data types.

Example

csharp

OracleDataReader pictureReader = myCommand.ExecuteReader();
pictureReader.Read();
OracleLob pictureBlob = pictureReader.GetOracleLob(pictureReader.GetOrdinal("Picture"));
if (pictureBlob.Length > 100)
  pictureBlob.SetLength(100);

Visual Basic

Dim pictureReader As OracleDataReader = myCommand.ExecuteReader
pictureReader.Read()
Dim pictureBlob As OracleLob = pictureReader.GetOracleLob(pictureReader.GetOrdinal("Picture"))
If (pictureBlob.Length > 100) Then
  pictureBlob.SetLength(CLng(100))
End If

Reference

OracleLob Class
OracleLob Members
SetLength Method

Send Feedback