SetLength Method

On this page

Sets length for OracleLob value.

Syntax

Visual Basic
C#


'Declaration Public Overrides Sub SetLength( _ ByVal len As Long _ )


public override void SetLength( long len )

Parameters

len: The size of the OracleLob in bytes.

Remarks

If the given value is less than the current length of the stream, the stream is truncated. If the given value is larger than the current length of the stream, the stream is expanded. If the stream is expanded, the contents of the stream between the old and the new length are undefined.

Example

csharp


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

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

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
Length Property

Send Feedback