Skip Headers
Oracle® Objects for OLE Developer's Guide
11g Release 2 (11.2) for Microsoft Windows

Part Number E12245-01
Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Index
Go to Feedback page
Contact Us

Go to previous page
Go to next page
View PDF

CopyFromBFILE (OraLOB) Method

Applies To

OraBLOB, OraCLOB Objects


Copies a portion or all of the LOB value of an OraBFILE object to the LOB value of this object.


OraBlob.CopyFromBFile srcBFile, amount, destOffset, srcOffset
OraClob.CopyFromBFile srcBFile, amount, destOffset, srcOffset


The arguments for the method are:

Arguments Description
[in] srcBFile An OraBFILE object from which the data is to be copied.
[in] [optional] amount An Integer specifying the maximum number to be copied, in characters for OraCLOB or bytes for OraBLOB or OraBFILE. Default value is the size of BFILE value of the srcBFile object.
[in] [optional] destOffset An Integer specifying the absolute offset for this instance. Default is 1.
[in] [optional] srcOffset An Integer specifying the absolute offset for the BFILE value of the source OraBFILE object. Default is 1.


Obtain either a row-level lock or object-level lock before calling this method.

For a single-byte character set, the OraBFile object should be of the same character set as the database.

If the database has a variable width character set, the OraBFile object passed to the OraClob.CopyFromBFile method must point to a file that uses the UCS2 character set.