UTL_RAW

Related Interfaces

Table 1 provides all interfaces supported by the UTL_RAW package.

The external representation of the RAW type data is hexadecimal and its internal storage form is binary. For example, the representation of the RAW type data 11001011 is 'CB'. The input of the actual type conversion is 'CB'.

• UTL_RAW.CAST_FROM_BINARY_INTEGER

  The stored procedure CAST_FROM_BINARY_INTEGER converts an INTEGER type value to a binary representation (RAW type).

  The UTL_RAW.CAST_FROM_BINARY_INTEGER function prototype is:

  Table 2 UTL_RAW.CAST_FROM_BINARY_INTEGER interface parameters

  Parameter	Description
  n	Specifies the INTEGER type value to be converted to the RAW type.
  endianess	Specifies the INTEGER type value 1 or 2 of the byte sequence. (1 indicates BIG_ENDIAN and 2 indicates LITTLE-ENDIAN.)

• UTL_RAW.CAST_TO_BINARY_INTEGER

  The stored procedure CAST_TO_BINARY_INTEGER converts an INTEGER type value in a binary representation (RAW type) to the INTEGER type.

  The UTL_RAW.CAST_TO_BINARY_INTEGER function prototype is:

  Table 3 UTL_RAW.CAST_TO_BINARY_INTEGER interface parameters

  Parameter	Description
  r	Specifies an INTEGER type value in a binary representation (RAW type).
  endianess	Specifies the INTEGER type value 1 or 2 of the byte sequence. (1 indicates BIG_ENDIAN and 2 indicates LITTLE-ENDIAN.)

• UTL_RAW.LENGTH

  The stored procedure LENGTH returns the length of a RAW type object.

  The UTL_RAW.LENGTH function prototype is:

  Table 4 UTL_RAW.LENGTH interface parameters

  Parameter	Description
  r	Specifies a RAW type object.

• UTL_RAW.CAST_TO_RAW

  The stored procedure CAST_TO_RAW converts a VARCHAR2 type object to the RAW type.

  The UTL_RAW.CAST_TO_RAW function prototype is:

  Table 5 UTL_RAW.CAST_TO_RAW interface parameters

  Parameter	Description
  c	Specifies a VARCHAR2 type object to be converted.

Examples