UTL_RAW.CAST_TO_VARCHAR2

From: Lei Zeng <leizeng2003_at_yahoo.com>
Date: Mon, 4 Feb 2013 14:09:21 -0800 (PST)
Message-ID: <1360015761.98721.YahooMailNeo_at_web140004.mail.bf1.yahoo.com>

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▒▒▒    _at_     ▒  @   @
      ▒▒gg▒  ▒ ▒▒▒▒▒▒  ▒▒
 

(((P  ▒  _at_)(((▒▒  ▒A▒
                      ▒▒ _at_ ▒  
How
I can get a meaningful string from UTL_RAW.CAST_TO_VARCHAR2? Did I miss anything?

Thanks in advance,
Lei

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

Received on Mon Feb 04 2013 - 23:09:21 CET