How to translate system defined error messages to the langauge selected [message #235191] |
Fri, 04 May 2007 05:02  |
rajesh4851
Messages: 89 Registered: January 2007
|
Member |
|
|
Hi,
we have multilinguil application(french,english etc).
We are using forms 10g. I got one problem. suppose i am accessing one form in French, In QUANITY field (number) i am enterning -1 but it should not allow negative values. it will give some error message like FRM-40207: "Must be in range -9999999.99 to 9999999.99". This err msg will be displayed in correspoindg to the langauge of the application.
Please give any idea regarding this.
Thanks & Regards,
Rajesh.
|
|
|
|
|
|
Re: How to translate system defined error messages to the langauge selected [message #235617 is a reply to message #235611] |
Mon, 07 May 2007 07:51   |
 |
Littlefoot
Messages: 21823 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
I don't think he talks about the external table (actually, a file system file which Oracle can read as if it was a table), but external as if it doesn't belong to the current schema.
How does your database look like? Is it one database for every location (so that people in France have one database, people in Spain another one etc.), or do they all access the same database (whose location is irrelevant)?
If it is only one database and all users access it, I *think* that you'll need to do something like @NATVA suggested. If, on the other hand, there is more than one database, could you install it in order to support different languages? You know - while setting up French database, make it speak French so that all messages (those you get in SQL*Plus, Forms, etc.) are in French. Do the same for all databases and that might be a solution for you.
Another possibility would be modifying (altering, actually) session for each user, but I'm not sure whether it will do what you need or not. I *think* not.
|
|
|
|
Re: How to translate system defined error messages to the langauge selected [message #236794 is a reply to message #235617] |
Fri, 11 May 2007 00:59   |
rajesh4851
Messages: 89 Registered: January 2007
|
Member |
|
|
Thanks for your suggession.
Actually the database is different for each country. One more thing is, we should do it at form level only. Should not use tables from database. I hope we need to set some parameters(like NLS_LANG,USER_NLS_LANG)at the time of installing of D2K. Could you please give exact idea what are the parameters need to be set??
Thanks in advance.
Regards,
Rajesh
|
|
|
|
Re: How to translate system defined error messages to the langauge selected [message #236873 is a reply to message #236822] |
Fri, 11 May 2007 03:28   |
rajesh4851
Messages: 89 Registered: January 2007
|
Member |
|
|
Actually oracle forms standard messages like FRM-40207,FRM 50024, FRM 40353,FRM 50026, FRM 50004 ,FRM-40209 should be displayed as per the application languge.
Example:
Expected:
Application is in German, then the messages should be displayed in German language. If the application is in Russia, messages should be displayed in Russian language etc.
Actual:
Application is in German, But the message displayed in English.
This is wrong.
Solution:
????????
Thanks & regards,
Rajesh
|
|
|
|
|
Re: How to translate system defined error messages to the langauge selected [message #237635 is a reply to message #235191] |
Tue, 15 May 2007 05:01   |
gacki
Messages: 33 Registered: May 2006 Location: Dueren, NRW, Germany
|
Member |
|
|
Create config section for each language you want to support in formsweb.cfg. For each language define a separate .env file, where in each you set the NLS_LANG parameter appropriate.
formsweb.cfg
[myapp.de]
envFile=default_de.env
.....
[myapp.en]
envFile=default_en.env
.....
[myapp.fr]
envFile=default_fr.env
.....
[myapp]
* here go the default settings
Restart the server and run your application with
http://<server>:<port>/forms90/f90servlet?config=myapp
The language is detected by the client browsers default language.
Gerald
[Updated on: Tue, 15 May 2007 05:01] Report message to a moderator
|
|
|
|
|