CAST_TO_VARCHAR2 function - Casts a VARBINARY value to VARCHAR2 value

The CAST_TO_VARCHAR2 function casts a VARBINARY value to a VARCHAR2 value.

Syntax

Read syntax diagramSkip visual syntax diagramUTL_RAW.CAST_TO_VARCHAR2( input)

Parameters

input
An input argument of type VARBINARY(32672) that specifies the value to be converted to VARCHAR2(32672).

Authorization

EXECUTE privilege on the UTL_RAW module.

Example

Example 1: The following example shows how to CAST a VARBINARY value to a VARCHAR2 value: 
db2 "select sysibmadm.utl_raw.cast_to_varchar2(bx'616263646566') from sample "

1          
-----------
          abcdef

  1 record(s) selected.