Oracle Objects for OLE
Release 9.0.1

Part Number A90173-01

Home

Book List

Contents

Master Index

Feedback

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 © 1996-2001, Oracle Corporation.

All Rights Reserved.

Home

Book List

Contents