Problem with UTL_RAW.CONVERT

I'm having trouble using the UTL_RAW.CONVERT function on Oracle 8.1.6. I've created the following examples to try to explain the problem.

If I try this:

select convert('Test','UTF8','US7ASCII') from dual;

I receive the expected result of 'Test'.

However, if I try this:
select utl_raw.cast_to_varchar2(utl_raw.convert(utl_raw.cast_to_raw('Test'), 'UTF8', 'US7ASCII')) from dual;

I receive the following error message:

ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "SYS.UTL_RAW", line 261
ORA-06512 at line 1

This seems to be a valid statement to me, but that isn't worth. I've tried many combinations with similar results. I've also tried using a PL/SQL package and storing all intermediate values in appropriate variables with identical results.

Am I delirious here or does Oracle need some tweaking perhaps. Any help would be appreciated.

Jim Received on Sat Dec 01 2001 - 23:58:55 CET