Home » Developer & Programmer » Forms » NLS_NUMERIC_CHARACTERS (Webfoms10g - Unix Aix)
NLS_NUMERIC_CHARACTERS [message #361644] Thu, 27 November 2008 04:24 Go to next message
divacam99
Messages: 5
Registered: June 2007
Junior Member
Hi,

I have a problem with nls_numeric_characters in Forms10.

Standard the decimal seperator is '.', group seperator is ','. In 5 applications, the decimal seperator should be ',' and the group seperator must be '.'.

I have tried with forms_dll(alter session...) and dbms_session.set_nls but both functions don't work. Is there a way to change the parameter nls_numeric_characters
in a webform application ?

Grtz,

Dirk
Re: NLS_NUMERIC_CHARACTERS [message #361740 is a reply to message #361644] Thu, 27 November 2008 19:05 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Oracle Server Reference Manual
NLS_NUMERIC_ CHARACTERS
This parameter specifies the decimal character and grouping separator, overriding those defined implicitly by NLS_TERRITORY. The decimal character separates the integer and decimal parts of a number. The grouping separator is the character returned by the number format mask G. For example, to set the decimal character to a comma and the grouping separator to a period, the parameter should be set as follows:

NLS_NUMERIC_CHARACTERS = ",."
Both characters are single byte and must be different. Either can be a space.

Note: When the decimal character is not a period (.) or when a group separator is used, numbers appearing in SQL statements must be enclosed in quotes. For example:

INSERT INTO SIZES (ITEMID, WIDTH, QUANTITY)
VALUES (618, '45,5', TO_NUMBER('1.234','9G999'));


David

PS I hope that quoting this amount of the reference manual falls within 'fair use'.
Re: NLS_NUMERIC_CHARACTERS [message #361775 is a reply to message #361740] Fri, 28 November 2008 01:07 Go to previous messageGo to next message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
OK, that's what the NLS_NUMERIC_CHARACTERS is.

However (or, as I understood the problem), Dirk would like to use ',.' in 5 applications and '.,' for the rest of them. So the question was: how to make every application use its own NLS_NUMERIC_CHARACTERS?
Re: NLS_NUMERIC_CHARACTERS [message #361792 is a reply to message #361775] Fri, 28 November 2008 01:55 Go to previous messageGo to next message
divacam99
Messages: 5
Registered: June 2007
Junior Member
You are correct Litlefoot,

I want to change the nls_numeric_parameter @runtime.

Grtz,

Dirk
Re: NLS_NUMERIC_CHARACTERS [message #362353 is a reply to message #361792] Tue, 02 December 2008 00:36 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Yes, use the 'alter session' in EACH form that uses the different characters but use BOTH characters, not just the single character as you showed us in your original post.

David
Previous Topic: store sound in databse (Urgent)
Next Topic: Generate OpenOffice document with CLIENT_OLE2
Goto Forum:
  


Current Time: Sun Dec 04 02:42:59 CST 2016

Total time taken to generate the page: 0.20457 seconds