I think that the ALTER SESSION command changes only the territory setting
for the database
and not for the Forms environment. If you want to change the territory for
the Forms on Windows
you should set the NLS_TERRITORY or NLS_LANG for the Forms ORACLE_HOME.
On UNIX just set the NLS_TERRITORY environment variable before you start
your application.
"Ralph" <crrs_at_airtel.net> wrote in message
news:85d0ec10.0205300411.2cbf3129_at_posting.google.com...
> I have to modify a program written in Forms 4.5 under Oracle 7.3.
>
> The numeric masks looks like 999G999D99
>
> This is prepared for spanish input. Normally decimal separator is comma
','
> and group separator is dot '.'
>
> For this specific form, they want to input the numeric data with the dot
as
> a decimal separator.
>
> I have added a trigger when-new-form-instance with the
>
> Forms_DDL('ALTER SESSION SET NLS_NUMERIC_CHARACTERS = ''.,''');
>
> or DBMS_SESSION.set_nls('nls_territory','america');
>
> or any other combination ( I have made many), but I always get an error
> FRM-40209 field must be of form 999G999D99
>
> I don't want to modify the program to change the mask.
>
> Any idea of what to do? Thanks
Received on Fri May 31 2002 - 07:50:42 CDT
