Xref: alice comp.databases.oracle.tools:17845
Path: alice!news-feed.fnsi.net!news.idt.net!news-peer.gip.net!news.gsl.net!gip.net!news.maxwell.syr.edu!nntp2.dejanews.com!nnrp1.dejanews.com!not-for-mail
From: vorbeck@my-dejanews.com
Newsgroups: comp.databases.oracle.tools
Subject: Re: [Q] Switching language in Developer 2000
Date: Mon, 26 Oct 1998 18:06:34 GMT
Organization: Deja News - The Leader in Internet Discussion
Lines: 102
Message-ID: <712dna$qc6$1@nnrp1.dejanews.com>
References: <36342C4D.97FE3D79@val.indra.es> <711sgi$3o0$1@nnrp1.dejanews.com>
X-Article-Creation-Date: Mon Oct 26 17:54:34 1998 GMT
X-Http-User-Agent: Mozilla/4.06 [en] (Win95; I)
X-Http-Proxy: 1.0 x10.dejanews.com:80 (Squid/1.1.22) for client 195.76.129.30

Hi Jürgen,

    Thanks for the tip. I tried it out and it works fine, yet it doesn't solve
my problem :(.

The thing is, it works for PL/SQL statements anywhere in my form. But I have
items with a format mask, like 999G999G999D99. Somehow these items remain
unaffected by the "alter session..." through the DBMS_SESSION.SET_NLS
command.

I have found out that I can change the registry value of NLS_LANG and then it
will really
reflect in my form. But the problem of this
is that it doesn't fit well into my original problem scenario:

1. Forms application with items with format masks like 999,999,999
2. The user where this application is installed happens to use a language
setting (NLS_LANG =
Spanish_Spain...)
which is incompatible with this format. The runtime will not let you introduce
any number into
such an item, given the format mask
above. It'll simply yield an error message.
3. The user cannot change this value in the registry, because he uses other
applications which
need HIS NLS_LANG setting.
4. Of course, the proper thing would be to change these format masks to use G
and D instead
of , and .
5. But there are many forms (750) for this application and there is no time at
the moment to
change it all.
6. So I was looking at a kind of temporary fix, altering the
NLS_NUMERIC_CHARACTERS to
'.,' so that the form
always works.

In the end, I have the feeling that the only solution would be something like
creating a startup
batch which would alter the registry
to change the NLS_LANG to "american_america..." and the start the runtime with
the main
form.

The disadvantage obviously is that if the user starts his other applications
they would find an
altered registry and would stop working properly.

A more refined solution would restore the registry right after starting the
form.

Anyway, as you can see, all this is quite ugly.

If anyone has an idea as to how to tackle this problem elegantly, I would be
extremely
thankful!

    So long,

        -- Martin

In article <711sgi$3o0$1@nnrp1.dejanews.com>,
  krooss@my-dejanews.com wrote:
> Hi Martin !
>
> If you want to change the session parameter, you can use the
> dbms_session package. Until now i've used only the NLS_SORT
> parameter ( like : dbms_session.set_nls('NLS_SORT','BINARY');  )
>  in one  projekt. I've call  the package in the
>  WHEN-NEW-FORM-INSTANCE trigger, after establishing the
> database connection. I hope this information will help you.
>
> Regards Juergen
>
>   vorbeck@val.indra.es wrote:
> >
> > Hi,
> >
> >     how can I achieve the following: I want to change the
> > NLS_NUMERIC_CHARACTERS value when running my forms.
> > The user needs to have a different configuration in the Windows 95
> > registry.
> > I tried changing it using dynamic SQL from within the form, executing an
> > "ALTER SESSION SET NLS_NUMERIC_CHARACTERS...", but to no avail.
> > It somehow ignores the values (why?)
> >
> > Is there a way to specify this value at startup time for my forms?
> >
> >     I would be very thankful for any hints on how to solve this problem,
> > as I have no clue...
> >
> >         Cheers,
> >
> >             -- Martin Vorbeck
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/       Search, Read, Discuss, or Start Your Own
>


-----== Posted via Deja News, The Leader in Internet Discussion ==-----
http://www.dejanews.com/rg_mkgrp.xp   Create Your Own Free Member Forum