Skip Headers

Oracle® Objects for OLE Developer's Guide
10g Release 1 (10.1)

Part Number B10118-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Master Index
Master Index
Go to Feedback page
Feedback

CopyFromFile (OraLOB) Method

Applies To

OraBLOB, OraCLOB

Description

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

Arguments
Description
[in] filename
A string specifying the absolute name and path for the file to be read.
[in] [optional] amount
An Integer specifying the maximum number in bytes to be copied. Default value is total file size.
[in] [optional] offset
An Integer specifying the absolute offset of the BLOB/CLOB value of this object, in bytes for OraBlob/OraBFile and characters for OraClob. Default value is 1.
[in][optional] chunksize
An Integer specifying the size for each read operation, in bytes. If Chunksize parameter is not set or 0, the value of the amount argument is used, which means the entire amount is transferred in one chunk.
Usage

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

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

Remarks

Either a row-level lock or object-level lock should be obtained before calling this method.

The file should be in the same format as the NLS_LANG setting.

Note: When manipulating LOBs using LOB methods, such as the Write and CopyFromFile, note that the LOB object will not automatically be trimmed if the length of the new data is smaller than the old data. Use the Trim (OraLob) method to shrink the LOB object to the size of the new data.

Example

Example: Using the CopyFromFile Method