The COPY procedures provide the capability to copy one
large object to another.
Note: The source and destination large objects must be the
same data type.
Syntax
>>-DBMS_LOB.COPY_BLOB--(--dest_lob--,--src_lob--,--amount------->
>--+-----------------------------------+--)--------------------><
'-,--dest_offset--+---------------+-'
'-,--src_offset-'
>>-DBMS_LOB.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.
Authorization
EXECUTE privilege on the DBMS_LOB
module.
DB2 10.5 for Linux, UNIX, and Windows