Oracle Objects for OLE
Release 8.1.7

Part Number A85257-01

Library

Product

Contents

Writing LOB Data

The Write method of OraBlob and OraClob writes data from a local buffer to a LOB in the database. The CopyFromFile (OraLob) method writes content of a local file to a LOB in the database.

Any operation that changes the value of a LOB, including Write, can only occur when the row the LOB is associated with has been locked. Also, if a LOB field is NULL, it must be first updated with an Empty Lob before it can be written to.

As mentioned in
Performance Considerations, LOB data can be written in one piece or in a series of multiple pieces.

·
Single Piece Write Operation

· Multiple Piece Write Operation


 
Oracle
Copyright copy; 1996-2000, Oracle Corporation.

All Rights Reserved.

Library

Product

Contents