COPY procedures

The COPY procedures provide the capability to copy one large object to another.

The source and destination large objects must be the same data type.

Syntax

COPY_BLOB(dest_lob,src_lob,amount [ ,dest_offset [ ,src_offset ] ] )
COPY_CLOB(dest_lob,src_lob,amount [ ,dest_offset [ ,src_offset ] ] )

Parameters

dest_lob
An input or output argument of type BLOB(10M) or CLOB(10M) that specifies the large object locator of the large object to which src_lob is to be copied. 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 of the large object from which dest_lob is to be copied. Must be the same data type as dest_lob.
amount
An input argument of type INTEGER that specifies the number of bytes or characters of src_lob to be copied.
dest_offset
An optional input argument of type INTEGER that specifies the position in the destination large object where writing of the source large object should begin. The first position is offset 1. The default is 1.
src_offset
An optional input argument of type INTEGER that specifies the position in the source large object where copying to the destination large object should begin. The first position is offset 1. The default is 1.