Re: FRENCH Date in Forms/Reports

Helen,

You need to set the NLS_LANG parameter appropriately. If you are using a PC, then you will have to edit the Registry.

1. Run REGEDIT - this brings up the Registry Editor
2. Navigate to HKEY_LOCAL_MACHINE->SOFTWARE->ORACLE
3. On the right pane, double click on the NLS_LANG entry to edit it.
4. The default should be AMERICAN_AMERICA.WE8ISO8859P1 Change this to FRENCH_FRANCE.WE8ISO8859P1
5. Exit REGEDIT
6. Restart your Oracle Form or Report

Note that this will only change Error messages issued by Forms or the Server.
To change menus or LOVs, you will have to take care of this during development,
possibly using the French version of Forms/Reports.

Look at the National Language Support appendix in the Forms Advanced Techniques
manual for more info.

Srini

huynuye_at_statcan.ca wrote:
>
> Hi,
>
> One way to display Date, Oracle messges in French is to intall Oracle Forms
> and Reports Runtime in French or modify your regedit.
>
> Alternatively, I want to use something like
> FORMS_DDL('ALTER SESSION set NLS_DATE_LANGUAGE=french'); -- in Forms
> to alter the session depends on who the user is
> This doesn't seem to work.
> Could someone help?
>
> Also how do I control language preference in my Forms/Reports so that
> Menu/ LOV and messages show up in French (without installing the Runtime in
> French)
>
> Thanks
> Helen
Received on Sat Nov 21 1998 - 04:28:05 CET