CONVERTTOBLOB procedure - Convert character data to binary

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

Syntax

Read syntax diagramSkip visual syntax diagramDBMS_LOB.CONVERTTOBLOB( dest_lob,src_clob,amount ,dest_offset,src_offset, blob_csid,lang_context,warning)

Parameters

dest_lob
An input or output argument of type BLOB(10M) that specifies the large object locator into which the character data is to be converted.
src_clob
An input argument of type CLOB(10M) that specifies the large object locator of the character data to be converted.
amount
An input argument of type INTEGER that specifies the number of characters of src_clob to be converted.
dest_offset
An input or output argument of type INTEGER that specifies the position (in bytes) in the destination BLOB where writing of the source CLOB should begin. The first byte is offset 1.
src_offset
An input or output argument of type INTEGER that specifies the position (in characters) in the source CLOB where conversion to the destination BLOB should begin. The first character is offset 1.
blob_csid
An input argument of type INTEGER that specifies the character set ID of the destination 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.