Re: Enterprise manager nls problem

On 22 May 2007 00:51:09 -0700, perivoj_at_net.hr wrote:

>I create sample function in sql:
>
>CREATE OR REPLACE function proba return number as
>--??¸?¨??´?¦ sample text
>begin
>return 9;
>end;
>
>
>And open it in em:
>
> return number as
>--??¸?¨??´?¦ sample text
>begin
>return 9;
>end;
>
>It is OK, but after edit/compile in em I get this:
>
> return number as
>-- ?� ?� ? ?� ? ?� ?� ? ?� ? sample text
>begin
>return 9;
>end;
>
>Why?
>
>
>
>Version and nls settings:
>
>SQL> select version from v$instance;
>
>VERSION
>-----------------
>10.2.0.2.0
>
>
>
>SQL> select * from v$nls_parameters;
>
>PARAMETER
>----------------------------------------------------------------
>VALUE
>----------------------------------------------------------------
>NLS_LANGUAGE
>CROATIAN
>
>NLS_TERRITORY
>CROATIA
>
>NLS_CURRENCY
>kn
>
>NLS_ISO_CURRENCY
>CROATIA
>
>NLS_NUMERIC_CHARACTERS
>.,
>
>NLS_CALENDAR
>GREGORIAN
>
>NLS_DATE_FORMAT
>DD.MM.RR
>
>NLS_DATE_LANGUAGE
>CROATIAN
>
>NLS_CHARACTERSET
>EE8MSWIN1250
>
>NLS_SORT
>CROATIAN
>
>NLS_TIME_FORMAT
>HH24:MI:SSXFF
>
>NLS_TIMESTAMP_FORMAT
>DD.MM.RR HH24:MI:SSXFF
>
>NLS_TIME_TZ_FORMAT
>HH24:MI:SSXFF TZR
>
>NLS_TIMESTAMP_TZ_FORMAT
>DD.MM.RR HH24:MI:SSXFF TZR
>
>NLS_DUAL_CURRENCY
>kn
>
>NLS_NCHAR_CHARACTERSET
>AL16UTF16
>
>NLS_COMP
>BINARY
>
>NLS_LENGTH_SEMANTICS
>BYTE
>
>NLS_NCHAR_CONV_EXCP
>FALSE
We need your NLS_SESSION_PARAMETERS and your NLS_DATABASE_PARAMETERS, especially the env var or registry string value NLS_LANG. Also one would need to know whether you connect directly to the database, or using the management console.

-- 
Sybrand Bakker
Senior Oracle DBA