Home » Developer & Programmer » Forms » How to translate system defined error messages to the langauge selected
How to translate system defined error messages to the langauge selected [message #235191] Fri, 04 May 2007 05:02 Go to next message
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 #235478 is a reply to message #235191] Sun, 06 May 2007 14:04 Go to previous messageGo to next message
NATVA
Messages: 9
Registered: May 2007
Junior Member
May be you can use a error table which has a language ID , just pass the language ID and get the error message ....

example

1 english
2 french
3 german



language ID ERROR NUMBER ( SEND FROM APPLICATION) MSG

1 4972 CAN'T BE NEGATIVE
2 4972 ( IN FRENCH)
3 4972 ( IN GENRMAN )
1 7842 CAN NOT BE NULL
ETC...
Re: How to translate system defined error messages to the langauge selected [message #235549 is a reply to message #235478] Mon, 07 May 2007 02:27 Go to previous messageGo to next message
rajesh4851
Messages: 89
Registered: January 2007
Member
But we should not use external table for this error handling. I think we need to set some parameters 'NLS_LANG','USER_NLS_LANG'.
Do you have any idea regarding this??

Thanks & regards,
Rajesh
Re: How to translate system defined error messages to the langauge selected [message #235611 is a reply to message #235549] Mon, 07 May 2007 07:00 Go to previous messageGo to next message
ab_trivedi
Messages: 460
Registered: August 2006
Location: Pune, India
Senior Member
why are using that earlier given solution in external table. create a table in database.
AT
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 Go to previous messageGo to next message
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 #236757 is a reply to message #235191] Thu, 10 May 2007 21:21 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Have a look at the OracleŽ Database Globalization Support Guide which supports the languages displayed at http://download-west.oracle.com/docs/cd/B19306_01/server.102/b14225/applocaledata.htm#sthref1949

David
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 Go to previous messageGo to next message
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 #236822 is a reply to message #236794] Fri, 11 May 2007 01:43 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Do you want multiple version of YOUR messages or of the system messages?

David
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 Go to previous messageGo to next message
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 #237268 is a reply to message #236873] Mon, 14 May 2007 00:47 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Okay, then go back to the link that I gave previously and work your way through the Globilisation guide. Its in there somewhere. My understanding is that you set the language and the text of the system messages change. Obviously they have to exist before they can be used but I believe that that is covered in the documentation.

David
[EDITED by DJM: fixed typo.]

[Updated on: Wed, 18 February 2009 00:02]

Report message to a moderator

Re: How to translate system defined error messages to the langauge selected [message #237598 is a reply to message #237268] Tue, 15 May 2007 01:52 Go to previous messageGo to next message
rajesh4851
Messages: 89
Registered: January 2007
Member
Ok, Thanks for your responce.

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 Go to previous messageGo to next message
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

Re: How to translate system defined error messages to the langauge selected [message #238458 is a reply to message #237635] Fri, 18 May 2007 03:00 Go to previous messageGo to next message
rajesh4851
Messages: 89
Registered: January 2007
Member
Thanks for the concern.
-Rajesh
Re: How to translate system defined error messages to the langauge selected [message #386821 is a reply to message #238458] Tue, 17 February 2009 02:08 Go to previous message
miguel.garcia
Messages: 1
Registered: February 2009
Location: SPAIN
Junior Member
Hi!
How you resolved that problem rajesh4851?
Thanks!
Previous Topic: How to pass parameter in query ( for in clause)?
Next Topic: Exit From Windwo in a form?
Goto Forum:
  


Current Time: Sat Feb 15 12:08:47 CST 2025