APPEND procedures - Append one large object to another

The APPEND procedures provide the capability to append one large object to another.

Note: Both large objects must be of the same type.

Syntax

Read syntax diagramSkip visual syntax diagramDBMS_LOB.APPEND_BLOB( dest_lob,src_lob)
Read syntax diagramSkip visual syntax diagramDBMS_LOB.APPEND_CLOB( dest_lob,src_lob)

Parameters

dest_lob
An input or output argument of type BLOB(10M) or CLOB(10M) that specifies the large object locator for the destination object. Must be the same data type as src_lob.
src_lob
An input argument of type BLOB(10M) or CLOB(10M) that specifies the large object locator for the source object. Must be the same data type as dest_lob.

Authorization

EXECUTE privilege on the DBMS_LOB module.