Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Enterprise manager nls problem

Enterprise manager nls problem

From: <perivoj_at_net.hr>
Date: 22 May 2007 00:51:09 -0700
Message-ID: <1179820269.317500.149490@w5g2000hsg.googlegroups.com>


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 Received on Tue May 22 2007 - 02:51:09 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US