CopyToFile (OraLOB/BFILE) Method

Applies To

OraBLOB, OraCLOB

OraBFILE

Description

Copies a portion or all of the internal LOB value of this object to the local file.

Arguments

[in] filename	A string specifying the absolute name and path for the file to be written to.
[in] [optional] amount	An Integer specifying the maximum number of bytes to be copied. Default value is the size of the LOB or BFILE.
[in] [optional] offset	An Integer specifying absolute offset of the LOB or BFILE value of this instance. Default value is 1.
in] [optional] ChunkSize	An Integer specifying the size for each write operation. If the Chunksize parameter is not set or is 0, the value of the amount argument is used which means the entire amount is transferred in one chunk.

Usage

OraBlob.CopyToFile "blob.bmp" amount,offset,chunksize

OraClob.CopyToFile "clob.txt" amount,offset,chunksize

OraBfile.CopyToFile "blob.bmp" amount,offset,chunksize

Remarks

If the file exists, its contents is over-written.

Example

Example: Using the CopyToFile Method