querying user_source results in unreadable text - need help to set NLS_LANG parameter

From: sundar mahadevan <sundarmahadevan82_at_gmail.com>
Date: Fri, 2 Oct 2009 16:07:17 -0400
Message-ID: <7d81ec570910021307o35697c7mfea501b38a80425f_at_mail.gmail.com>

Hi Gurus,

I 'm trying to read the text from user_source with the query " select text from user_source where name ='DBMS_REDEFINITION' and type = 'PACKAGE BODY' " but I get unreadable text. I believe it might be a problem with NLS_SETTINGS. Understanding that NLS_LANG settings are only for client machines, I get the same output on both client and server machines. I tried setting NLS_LANG=AMERICAN_AMERICA.AL32UTF8, AMERICAN_AMERICA.AL16UTF16 and AMERICAN_AMERICA.WE8ISO8859P1. My client is xp and my server is OEL5.3 Please help. Thanks in advance.

SQL> select name,value$ from sys.props$ where upper(name) like '%CHAR%';

NAME                                           VALUE$

NLS_NUMERIC_CHARACTERS         .,
NLS_CHARACTERSET                  AL32UTF8
NLS_NCHAR_CONV_EXCP            FALSE
NLS_NCHAR_CHARACTERSET     AL16UTF16

select * from sys.props$ where upper(name) like '%NLS%'

NLS_LANGUAGE       AMERICAN        Language
NLS_TERRITORY       AMERICA          Territory

select text from user_source where name ='DBMS_REDEFINITION' and type = 'PACKAGE BODY'; TEXT

---

Qc+4To55K567uRbC5aHwg3ut8NN3p3i+XGTRxGP4FvqUUbPXbkb3KEhBUdfyiK6yZ0Fu1I55 K567uRbC5aHwg3ut8NN3p3i+XGTRxGP4FvqUUbPXbkb363VR1/KIrvD7fKZYR5CrqVW+/8oC R/HVG1fw+heaG7WHbFm4q7dyvC4n1a/e0jbqWbj6neq9tnEJ2npEg3oheDWeWGxPENVC5Fj7 tABePvjflQeSJkkCBdiOHaYrmd0Xmhu1h2y4gEGnJ9WvJzdyvC4n1e5KejqPiz6D2I4dpiuZ

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

Received on Fri Oct 02 2009 - 15:07:17 CDT