| NLS_NUMERIC_CHARACTERS [message #361644] |
Thu, 27 November 2008 04:24  |
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  |
 |
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS 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 #362353 is a reply to message #361792] |
Tue, 02 December 2008 00:36 |
|
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS 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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
