The APPEND stored procedure appends the content of a source internal LOB to a target LOB.
Syntax
DBMS_LOB. APPEND (
dest_lob IN OUT NOCOPY BLOB,
src_lob IN BLOB);
DBMS_LOB.APPEND (
dest_lob IN OUT NOCOPY CLOB CHARACTER SET ANY_CS,
src_lob IN CLOB CHARACTER SET ANY_CS);
Parameters
| Parameter | Description |
|---|---|
| dest_lob | The locator of the internal LOB to which you want to append data. |
| src_lob | The locator of the internal LOB from which data is read. |
Exceptions
| Exception | Description |
|---|---|
| VALUE_ERROR | The source LOB or target LOB is NULL. |
| QUERY_WRITE | Cannot perform a LOB write inside a query or PDML parallel execution server. |
| BUFFERING_ENABLED | The operation cannot be performed because LOB buffering is enabled. |
Usage notes
You can choose not to wrap the
LOBoperation inside the Open/Close API. If you did not open theLOBbefore the operation, the functional and domain indexes on theLOBcolumn are updated during the call. However, if you opened theLOBbefore the operation, you must close it before you commit the transaction. When an internalLOBis closed, the functional and domain indexes on theLOBcolumn are updated.If you do not wrap the
LOBoperation in the Open/Close API, the functional and domain indexes are updated each time you write to theLOB. To avoid adversely affecting performance, we recommend that you wrap write operations on theLOBin theOPENorCLOSEstatement.If
APPENDis called on an archivedLOB, it implicitly obtains theLOBbefore the first byte is written.