OraFAQ Forum: Forms » Forms 6i - Over-ride NLS settings ?

Home » Developer & Programmer » Forms » Forms 6i - Over-ride NLS settings ?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Forms 6i - Over-ride NLS settings ? [message #244947]

Thu, 14 June 2007 12:51

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!

Report message to a moderator

Re: Forms 6i - Over-ride NLS settings ? [message #245048 is a reply to message #244947]

Fri, 15 June 2007 01:22

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

Report message to a moderator

Re: Forms 6i - Over-ride NLS settings ? [message #245100 is a reply to message #245048]

Fri, 15 June 2007 03:08

johnmo
Messages: 2
Registered: June 2007

Junior Member

Quote:

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.

Report message to a moderator

Re: Forms 6i - Over-ride NLS settings ? [message #245495 is a reply to message #245100]

Sun, 17 June 2007 21:18

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Mar 12 06:37:52 CDT 2025