|Oracle Objects for OLE
Part Number A95895-01
This method reads the data from a long or long raw field into a variant and returns the amount of data read.
amount_read = orafield.GetChunkByteEx( ByteArray, offset, numbytes)
||the name of the variant ByteArray which will hold the data
||the number of bytes of the field to skip before copying data
||the number of bytes to copy
When possible, GetChunkByteEx retrieves the specified bytes from the local cache. However, to conserve resources, some of the data might not be stored locally. In such cases, GetChunkByteEx requests the necessary data from the database as required. As part of this process, data from all fields (except the Long or Long Raw field) in the dynaset are retrieved and compared with the cached values for consistency. If any changes have occurred since the fetch of the original partial data, then GetChunkByteEx aborts the operation with an error.
Since GetChunkByteEx takes in a variant as the first parameter, instead of the first element of the ByteArray as in GetChunkByte, only GetChunkByteEx can be used within an ASP/IIS environment.
If a long or long raw field is less than 65280 bytes in size, it is quicker to retrieve the data using the Value property than using GetChunkByteEx.
See Migration from Long Raw to LOB/BFILE for additional information.