| Oracle9i Supplied PL/SQL Packages and Types Reference Release 1 (9.0.1) Part Number A89852-02 |
|
UTL_RAW , 12 of 22
This function converts the bytes in the input RAW r according to the bytes in the transliteration RAWs from_set and to_set. Successive bytes in r are looked up in the from_set, and, if not found, copied unaltered to the result RAW. If found, then they are replaced in the result RAW by either corresponding bytes in the to_set, or the pad byte when no correspondence exists.
Bytes in r, but undefined in from_set, are copied to the result. Only the first (leftmost) occurrence of a byte in from_set is used. Subsequent duplicates are not scanned and are ignored. The result RAW is always the same length as r.
If the to_set is shorter than the from_set, then the pad byte is placed in the result RAW when a selected from_set byte has no corresponding to_set byte (as if the to_set were extended to the same length as the from_set with pad bytes).
UTL_RAW.TRANSLITERATE ( r IN RAW, to_set IN RAW DEFAULT NULL, from_set IN RAW DEFAULT NULL, pad IN RAW DEFAULT NULL) RETURN RAW;
pragma restrict_references(transliterate, WNDS, RNDS, WNPS, RNPS);
| Optional Parameter | Description |
|---|---|
from_set |
x'00 through x'ff. |
to_set |
To the |
pad |
x'00'. |
| Return | Description |
|---|---|
RAW |
Converted byte-string. |
| Error | Description |
|---|---|
VALUE_ERROR |
|
|
|
![]() Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|