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

On 22 May 2007 00:51:09 -0700, perivoj (AT) net (DOT) hr wrote:

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

Thank you for replying.



SQL> select * from NLS_SESSION_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_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_COMP BINARY
NLS_LENGTH_SEMANTICS BYTE
NLS_NCHAR_CONV_EXCP FALSE

--

SQL> select * from NLS_DATABASE_PARAMETERS;

PARAMETER VALUE
------------------------------
----------------------------------------
NLS_LANGUAGE CROATIAN
NLS_TERRITORY CROATIA
NLS_CURRENCY kn
NLS_ISO_CURRENCY CROATIA
NLS_NUMERIC_CHARACTERS .,
NLS_CHARACTERSET EE8MSWIN1250
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT DD.MM.RR
NLS_DATE_LANGUAGE CROATIAN
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_COMP BINARY
NLS_LENGTH_SEMANTICS BYTE
NLS_NCHAR_CONV_EXCP FALSE
NLS_NCHAR_CHARACTERSET AL16UTF16
NLS_RDBMS_VERSION 10.2.0.2.0


--

Key Name: HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE
\KEY_OraDb10g_home1
Class Name: Application Global Data
Last Write Time: 16.5.2007 - 14:23

.....

Value 3
Name: NLS_LANG
Type: REG_SZ
Data: CROATIAN_CROATIA.EE8MSWIN1250

.....



I connect using: Oracle Enterprise Manager Database Control 10.2.0.1
and only there I have this problem.