APPEND

The APPEND stored procedure appends the content of an internal source 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

Exceptions

Considerations

• You do not have to wrap LOB operations in the Open/Close interface. If you do not open a LOB before performing an operation, the function index and domain index on the LOB column will be updated during the operation. However, if you open a LOB before performing an operation, you must close it before committing the transaction. When you close an internal LOB, the function index and domain index on the LOB column will be updated.

  If you do not wrap LOB operations in the Open/Close interface, the function index and domain index on the LOB column will be updated every time you write to the LOB. To avoid affecting performance, we recommend that you include LOB write operations in OPEN or CLOSE statements.

• If you call APPEND on an archived LOB, it will implicitly acquire the LOB before writing the first byte.