[q] forms45, to_char and nls support

From: Igor M. Klinchin <karmen_at_whale.sunbay.crimea.ua>
Date: 1997/02/19
Message-ID: <5eef1o$qpj_at_ark.cris.crimea.ua>#1/1

Dear Oracle people,

I have found the strange problem in to_char function behaviour. I am using Dev/2000 v1.3 for Windows NT with GERMAN territory set in NLS_LANG environment variable.

When I tried to convert a number as:
foo := to_char(12345.67, 'FM999G999G990D90'); then I got the result as:
12,345.67
instead of: 12.345,67.

Nevetherless when I tried to use this function in sql*plus (pl/sql v2.3) then I achieved the desirable result:

SQL> select to_char(12345.67, 'FM999G999G990D90') to_char from dual; TO_CHAR

---

12.345,67

I hope that it is not the bug in the Forms but just my misunderstanding. Could you help me to understand the situation?

Thanks, dk

--

Igor M. Klinchin (IK38)                 e-mail: karmen_at_sunbay.crimea.ua
Sunbay DG                               ph. 380-652-27-6236(24) (work)
                                            380-652-27-1269     (home)

----------========= With the day came the resolution =========----------
Received on Wed Feb 19 1997 - 00:00:00 CET