Posted By: DoDo THIS IS FRUSTRATING AND DANGEROUS - 03/19/10 03:17 PM
PL/DEV SETTING:
DECIMAL SYMBOL = .
DIGIT GROUP SYMBOL = ,

NLS PARAMETERS:
nls_language = CROATIAN
nls_territory = CROATIA
nls_numeric_characters = empty (derived from nls_territory ,. )

NLS DATABASE PARAMETERS:
NLS_LANGUAGE = AMERICAN
NLS_TERRITORY = AMERICA
NLS_NUMERIC_CHARACTERS = .,

WHY PLDEV IN SLQ/WINDOW USES "derived from nls_territory" when I explicitly want ., ???????????

This is bad! I've allready had few "situations" with this.

EXAMPLE:
When I duplicate row in SQL/WINDOW results with COPY/PASTE, numbers are displayed as "123.45" but after submit requery shows that in database was stored "12345" !!!
Posted By: Marco Kalter Re: THIS IS FRUSTRATING AND DANGEROUS - 03/22/10 11:56 AM
If I understand correctly your decimal character is a "." in PL/SQL Developer (set through the preferences), but the Oracle Session is using a "," (derived from nls_territory). Is that correct?
Posted By: DoDo Re: THIS IS FRUSTRATING AND DANGEROUS - 03/22/10 12:22 PM
Yes, but only when submitting data (WRONG) , not when fetching(OK).
Posted By: Marco Kalter Re: THIS IS FRUSTRATING AND DANGEROUS - 03/23/10 10:16 AM
Can you let me know your setting of the "Number fields to_char" preference (Tools > Preferences > SQL Window)?
Posted By: DoDo Re: THIS IS FRUSTRATING AND DANGEROUS - 03/25/10 11:54 AM
Default (Green) (Not checked)
Posted By: DoDo Re: THIS IS FRUSTRATING AND DANGEROUS - 03/30/10 09:06 AM
Any news Marco?
Posted By: Marco Kalter Re: THIS IS FRUSTRATING AND DANGEROUS - 03/30/10 09:24 AM
We have not yet been able to reproduce this issue.
© Allround Automations forums