The UTL_ENCODE package provides functionality to encode RAW data into standard formats for transmission between hosts.
You can use the UTL_ENCODE functions to encode the body of email text. This package also includes corresponding decoding functions for encoded data. These functions adhere to published encoding standards to ensure compatibility with applications at both the sending and receiving ends.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition does not support this feature.
Overview of UTL_ENCODE subprograms
The following table lists the UTL_ENCODE subprograms supported in the current version of OceanBase Database and provides a brief description of each.
Subprogram |
Description |
|---|---|
| BASE64_DECODE | Reads a Base64-encoded RAW input string and decodes it into the original RAW value. |
| BASE64_ENCODE | Encodes the binary representation of a RAW value into Base64 elements and returns the result as a RAW string. |
| MIMEHEADER_DECODE | Decodes a string encoded in the MIME header format (RFC 2047). |
| MIMEHEADER_ENCODE | Encodes a string into a string that complies with the MIME header format (RFC 2047). |
| QUOTED_PRINTABLE_DECODE | Reads a RAW input string encoded in the Quoted-printable format and decodes it into the original RAW value. |
| QUOTED_PRINTABLE_ENCODE | Encodes a RAW value into the Quoted-printable format and returns the result as a RAW string. |
| TEXT_DECODE | Decodes a string encoded by TEXT_encode. |
| TEXT_encode | Encodes a string using the specified character set and encoding method. |
| UUDECODE | Reads a RAW input string encoded in the uuencode format and decodes it into the original RAW value. |
| UUENCODE | Encodes a RAW value into the uuencode format and returns the result as a RAW string. |