Enterprise manager nls problem
- From: perivoj@xxxxxx
- Date: 22 May 2007 00:51:09 -0700
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
.
- Follow-Ups:
- Re: Enterprise manager nls problem
- From: sybrandb
- Re: Enterprise manager nls problem
- Prev by Date: Re: RAC
- Next by Date: Temp-Contention
- Previous by thread: RMAN ASM Manual Clone (not using duplicate)
- Next by thread: Re: Enterprise manager nls problem
- Index(es):
Relevant Pages
|
Loading