WRITEAPPEND

The WRITEAPPEND stored procedure appends a specified amount of data to the end of a specified internal LOB. The data to be written comes 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 form of the VARCHAR buffer must match the form of the CLOB parameter. If the type of the input LOB parameter is CLOB, the data in the buffer must be of the CHAR type.

• When you call DBMS_LOB.WRITEAPPEND from the client, such as in a BEGIN or END block in OBClient, data in the buffer must use the client’s character set. Before the data is written from the buffer to the LOB, the database converts the character set of the client’s buffer to the character set of the server.

• You can choose not to wrap the LOB operation inside the Open/Close API. If you did not open the LOB before the operation, the functional and domain indexes on the LOB column are updated during the call. However, if you opened the LOB before the operation, you must close it before you commit the transaction. When an internal LOB is closed, the functional and domain indexes on the LOB column are updated.

• If you do not wrap the LOB operation in the Open/Close API, the functional and domain indexes are updated each time you write to the LOB. This may adversely affect performance. Therefore, we recommend that you wrap write operations on the LOB in the OPEN or CLOSE statement.

• When necessary, WRITEAPPEND obtains the LOB before it appends data to it.