dotConnect for Oracle Documentation
Devart.Data.Oracle Namespace / OracleLob Class / SetLength Method
The size of the OracleLob in bytes.
Example

In This Topic
    SetLength Method
    In This Topic
    Sets length for OracleLob value.
    Syntax
    '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
    OracleDataReader pictureReader = myCommand.ExecuteReader();
    pictureReader.Read();
    OracleLob pictureBlob = pictureReader.GetOracleLob(pictureReader.GetOrdinal("Picture"));
    if (pictureBlob.Length > 100)
      pictureBlob.SetLength(100);
    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
    See Also