Home » Developer & Programmer » Forms » Forms 6i - Over-ride NLS settings ?
Forms 6i - Over-ride NLS settings ? [message #244947] Thu, 14 June 2007 12:51 Go to next message
johnmo
Messages: 2
Registered: June 2007
Junior Member
Forms 6i on Windows-2000, Oracle Server 9i

I have an existing Forms/Reports application that uses one currency, and I want to be able to re-use it on the same client PC but using a different currency.

Ideally I would like to over-ride the NLS settings in the client registry e.g. by doing an Alter Session set NLS_CURRENCY.

However, I've tried that and it doesn't work (it does not fail, but it seems to have no effect).

Is there a way to over-ride the NLS_CURRENCY?

If not, is there a way to create a new minimal Oracle_Home in the registry containing another NLS_CURRENCY value and make the entry Form get the appropriate Oracle_Home? The app does not need to run concurrently with both currencies.

Thanks!
Re: Forms 6i - Over-ride NLS settings ? [message #245048 is a reply to message #244947] Fri, 15 June 2007 01:22 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Sorry to seem obtuse but would you be so kind as to attach or imbed the script that you use to run your Forms 6i session. Is there a cinfiguration section you could modify that set the environment on the PC or Application Server to have the different currency codes?

David
Re: Forms 6i - Over-ride NLS settings ? [message #245100 is a reply to message #245048] Fri, 15 June 2007 03:08 Go to previous messageGo to next message
johnmo
Messages: 2
Registered: June 2007
Junior Member
Quote:
Sorry to seem obtuse but would you be so kind as to attach or imbed the script that you use to run your Forms 6i session. Is there a cinfiguration section you could modify that set the environment on the PC or Application Server to have the different currency codes?


Hi David, thanks for your reply.

This is running in client-server mode, so no Application Server is involved, and no configuration scripts, although if anyone can think of something a script can do that would help, I'd be glad to hear about it.
Re: Forms 6i - Over-ride NLS settings ? [message #245495 is a reply to message #245100] Sun, 17 June 2007 21:18 Go to previous message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Have you tried using an 'alter session' command to change the currency?

David
Previous Topic: built-in callendar
Next Topic: Migration from Oracle 4.5i forms to Oracle 9i forms
Goto Forum:
  


Current Time: Mon Mar 10 09:36:43 CDT 2025