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