dotConnect for Oracle Documentation
Devart.Data.Oracle Namespace / OracleLob Class / Length Property
Example

On this page
    Length Property (OracleLob)
    On this page
    Gets the size of the OracleLob.
    Syntax
    '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
    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