SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Piecewise conversion via UTL_I18N.RAW_TO_CHAR

xxsawerJan 22 2021

Hi,
I was recently implementing piecewise conversion via UTL_I18N.RAW_TO_CHAR and I am wondering for what is the shift_status parameter?

UTL_I18N.RAW_TO_CHAR (
   data            IN RAW,
   src_charset     IN VARCHAR2 DEFAULT NULL,
   scanned_length  OUT PLS_INTEGER,
   shift_status    IN OUT PLS_INTEGER)
RETURN VARCHAR2

To me it seems the value is always 0 regardless of whether the data were converted fully or only a part of it. I also tried a conversion from UTF8 providing non-existing byte combination hoping the value has meaning like status of the conversion, but it also returned 0.
Thanks in advance for your hints.

Added on Jan 22 2021

1 comment

829 views