Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Enterprise manager nls problem
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
SQL> select * from v$nls_parameters;
PARAMETER
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
Received on Tue May 22 2007 - 02:51:09 CDT
![]() |
![]() |