Home » Developer & Programmer » Forms » "Could not reserve record" message
"Could not reserve record" message [message #124823] Tue, 21 June 2005 13:14 Go to next message
mihaimateiescu
Messages: 5
Registered: June 2005
Location: Bucharest
Junior Member

Hi. I am a student from Romania and i have a question for you.
I made a small application using Oracle Forms6, and i would like to know if there is a way to change the message "Could not reserve record".
I only want that message to be displayed in romanian.

Is there a way to accomplish this?





Thanks a lot for your time.

Mihai

[Updated on: Tue, 21 June 2005 13:14]

Report message to a moderator

Re: "Could not reserve record" message [message #124882 is a reply to message #124823] Wed, 22 June 2005 01:03 Go to previous messageGo to next message
arobinson98
Messages: 8
Registered: June 2005
Junior Member
There's a form level trigger you can use called ON_MESSAGE which allows a developer to code an action when a message occurs. In your case it would be to display a different message (in romanian perhaps) Here's a sample of code we use.

note - message_code 40400 is the code returned when a record is successfully saved.

DECLARE
msgnum NUMBER := MESSAGE_CODE;
msgtxt VARCHAR2(80) := MESSAGE_TEXT;
msgtyp VARCHAR2(3) := MESSAGE_TYPE;
BEGIN
IF msgnum = 40400 THEN
message('Changes Saved!');
END IF;
END;
Re: "Could not reserve record" message [message #124884 is a reply to message #124882] Wed, 22 June 2005 01:21 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
You can also look at running the whole database and application server in another language by changing the NLS_LANGUAGE setting.

Have a look at the reference in http://www.orafaq.com/forum/m/114853/67467/?srch=nls#msg_114853.

David

[Updated on: Wed, 22 June 2005 01:21]

Report message to a moderator

Re: "Could not reserve record" message [message #124905 is a reply to message #124884] Wed, 22 June 2005 04:26 Go to previous messageGo to next message
mihaimateiescu
Messages: 5
Registered: June 2005
Location: Bucharest
Junior Member

This isn't a message.
I cannot use ON_MESSAGE triggers
Re: "Could not reserve record" message [message #125039 is a reply to message #124905] Wed, 22 June 2005 18:49 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Okay. If the message ins't a message then I assume it does not have an Oracle prefix either. Is this correct?

David
Re: "Could not reserve record" message [message #125087 is a reply to message #125039] Thu, 23 June 2005 04:14 Go to previous messageGo to next message
mihaimateiescu
Messages: 5
Registered: June 2005
Location: Bucharest
Junior Member

Exactly
Re: "Could not reserve record" message [message #125221 is a reply to message #125087] Thu, 23 June 2005 19:11 Go to previous message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Okay ... forget what I wrote. I'll try a different angle in a minute.

I think we have to look at the NLS_LANGUAGE and NLS_LANG settings on the Application Server and possibly the Database.

Let's use the reference in http://www.orafaq.com/forum/m/115177/67467/?srch=nls#msg_115177 which says "The General FAQ suggests going to Oracle documentation at http://www.oracle.com/technology/documentation/. Use the 'search' facility on the top line and search for 'NLS', go to 'Results for Oracle 8i' - 'Search this documentation library for "nls"', and then go to the 'National Language Support Guide'."

The PDF is at http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a76966.pdf, try the NLS_LANG settings to set the machines to Romanian.

David

[Updated on: Thu, 23 June 2005 19:42]

Report message to a moderator

Previous Topic: Forms developers resources
Next Topic: Master-Detail
Goto Forum:
  


Current Time: Fri Sep 20 10:48:17 CDT 2024