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

On Fri, Oct 2, 2009 at 4:07 PM, sundar mahadevan < sundarmahadevan82_at_gmail.com> wrote:

> 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
>
>
>

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