CONVERTTOCLOB procedure - Convert binary data to character

The CONVERTTOCLOB procedure provides the capability to convert binary data to character.

Syntax

Read syntax diagramSkip visual syntax diagramDBMS_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.