UTL_RAW.CAST_TO_VARCHAR2

From: Lei Zeng <leizeng2003@xxxxxxxxx>
To: ORACLE- L <oracle-l@xxxxxxxxxxxxx>
Date: Mon, 4 Feb 2013 14:09:21 -0800 (PST)

Hi, list:
I
have a quick question about UTL_RAW.CAST_TO_VARCHAR2

Database
version 11.2.0.2
Database
character set UTF8
I
set NLS_LANG before using SQLPLUS

export
NLS_LANG=AMERICAN_AMERICA.UTF8
SQL>Â  select
utl_raw.cast_to_varchar2(OPTIMIZER_ENV)
Â  from DÂ  2Â  BA_HIST_OPTIMIZER_ENV where
optimizer_env_hash_value)66359101;
Â 
UTL_RAW.CAST_TO_VARCHAR2(OPTIMIZER_ENV)
--------------------------------------------------------------------------------
ââââ&â
= ââââââ3 VAEUQâ!UUUETUXYUDâeâUâUUQUQQ"UTââ
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â 
Â Â Â Â Â Â Â Â Â  UQEBeETTââVn
Â  âETPDiâââÂ Â Â  @Â Â Â Â  âÂ  @Â Â  @
Â Â Â Â Â  ââggâÂ  â ââââââÂ  ââ
Â 
(((PÂ  âÂ  @)(((ââÂ  âAâ
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  ââ @ â
Â 
How
I can get a meaningful string from UTL_RAW.CAST_TO_VARCHAR2?
Did I miss anything?

Thanks in advance,
Lei

--
//www.freelists.org/webpage/oracle-l

Follow-Ups:
- Re: UTL_RAW.CAST_TO_VARCHAR2
  - From: rjamya

UTL_RAW.CAST_TO_VARCHAR2

Other related posts: