CONVERTTOCLOB procedure - Convert binary data to character

Syntax

>>-DBMS_LOB.CONVERTTOCLOB--(--dest_lob--,--src_blob--,--amount--,-->

>--dest_offset--,--src_offset--,--blob_csid--,------------------>

>--lang_context--,--warning--)---------------------------------><

Parameters

dest_lob

An input or output argument of type CLOB(10M) that specifies the large object locator into which the binary data is to be converted.

src_clob

An input argument of type BLOB(10M) that specifies the large object locator of the binary data to be converted.

amount

An input argument of type INTEGER that specifies the number of characters of src_blob to be converted.

dest_offset

An input or output argument of type INTEGER that specifies the position (in characters) in the destination CLOB where writing of the source BLOB should begin. The first byte is offset 1.

src_offset

An input or output argument of type INTEGER that specifies the position (in bytes) in the source BLOB where conversion to the destination CLOB should begin. The first character is offset 1.

blob_csid

An input argument of type INTEGER that specifies the character set ID of the source BLOB. This value must match the database codepage.

lang_context

An input argument of type INTEGER that specifies the language context for the conversion. This value must be 0.

warning

An output argument of type INTEGER that always returns 0.

Authorization

EXECUTE privilege on the DBMS_LOB module.