GetChunkByteEx Method

Applies To

OraField Object

Description

This method reads the data from a long or long raw field into a variant and returns the amount of data read.

Usage

amount_read = orafield.GetChunkByteEx( ByteArray, offset, numbytes)

Arguments	Description
ByteArray	the name of the variant ByteArray which will hold the data
offset	the number of bytes of the field to skip before copying data
numbytes	the number of bytes to copy

Remarks

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.

Examples

Example: Using GetChunkByteEx to Retrieve a LONG RAW

Example: Using GetChunkByteEx Method with ASP