Offset (OraLOB/BFILE) Property

Applies To

OraBLOB, OraCLOB

OraBFILE

Description

Gets or sets the 1-based offset into the LOB/BFile for the next Read or Write operation. This property is read/write at runtime.

Usage

offsetbytes = OraBFile.Offset

OraBFile.Offset = offsetbytes

offsetbytes = OraBlob.Offset

OraBlob.Offset = offsetbytes

offsetchars = OraClob.Offset

OraClob.Offset = offsetchars

Remarks

This value is expressed in of bytes for OraBlob/OraBFILE or characters for OraClob. The default value is 1. Setting this value to zero will raise an error. When the PollingAmount property is not zero (polling is enabled), the Offset property can only be set before the first Read or Write, or after the current polling operation has completed.

Data Type

Integer