WRITEAPPEND

The WRITEAPPEND procedure writes a specified amount of data to the end of an internal LOB. The data is written from the buffer parameter.

Syntax

DBMS_LOB.WRITEAPPEND (
lob_loc IN OUT NOCOPY BLOB,
amount  IN            INTEGER,
buffer  IN            RAW);

DBMS_LOB.WRITEAPPEND (
lob_loc IN OUT NOCOPY CLOB CHARACTER SET ANY_CS,
amount  IN            INTEGER,
buffer  IN            VARCHAR2 CHARACTER SET ANY_CS);

Parameters

Exceptions

Considerations

• The VARCHAR buffer must match the format of the CLOB parameter. If the input LOB parameter is of type CLOB, the buffer must contain CHAR data.

• When you call DBMS_LOB.WRITEAPPEND from a client (for example, in an BEGIN/END block in OBClient), the buffer must contain data in the client character set. Before writing the buffer data to the LOB, the database converts the client buffer to the server character set.

• You do not need to wrap LOB operations in an open/close interface. If the LOB is not open before the operation, the function index and domain index on the LOB column are updated during the call. However, if the LOB is open before the operation, you must close it before committing the transaction. Closing the internal LOB updates the function index and domain index on the LOB column.

• If you do not wrap LOB operations in an open/close API, the function index and domain index are updated each time you write to the LOB. This can negatively impact performance. Therefore, we recommend that you include LOB write operations in an OPEN or CLOSE statement.

• When you append data to a LOB, the WRITEAPPEND procedure retrieves the LOB.