|
THIS IS FRUSTRATING AND DANGEROUS
|
Joined: Mar 2007
Posts: 147 Zagreb, Croatia
Member
|
OP
Member
Joined: Mar 2007
Posts: 147 Zagreb, Croatia |
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" !!!
DoDo -------------------------------------------- Be happy, tomorrow it can become only worse. If not, even better!
|
|
|
Re: THIS IS FRUSTRATING AND DANGEROUS
|
Joined: Aug 1999
Posts: 22,200
Member
|
Member
Joined: Aug 1999
Posts: 22,200 |
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?
Marco Kalter Allround Automations
|
|
|
Re: THIS IS FRUSTRATING AND DANGEROUS
|
Joined: Mar 2007
Posts: 147 Zagreb, Croatia
Member
|
OP
Member
Joined: Mar 2007
Posts: 147 Zagreb, Croatia |
Yes, but only when submitting data (WRONG) , not when fetching(OK).
DoDo -------------------------------------------- Be happy, tomorrow it can become only worse. If not, even better!
|
|
|
Re: THIS IS FRUSTRATING AND DANGEROUS
|
Joined: Aug 1999
Posts: 22,200
Member
|
Member
Joined: Aug 1999
Posts: 22,200 |
Can you let me know your setting of the "Number fields to_char" preference (Tools > Preferences > SQL Window)?
Marco Kalter Allround Automations
|
|
|
Re: THIS IS FRUSTRATING AND DANGEROUS
|
Joined: Mar 2007
Posts: 147 Zagreb, Croatia
Member
|
OP
Member
Joined: Mar 2007
Posts: 147 Zagreb, Croatia |
Default (Green) (Not checked)
DoDo -------------------------------------------- Be happy, tomorrow it can become only worse. If not, even better!
|
|
|
Re: THIS IS FRUSTRATING AND DANGEROUS
|
Joined: Mar 2007
Posts: 147 Zagreb, Croatia
Member
|
OP
Member
Joined: Mar 2007
Posts: 147 Zagreb, Croatia |
DoDo -------------------------------------------- Be happy, tomorrow it can become only worse. If not, even better!
|
|
|
Re: THIS IS FRUSTRATING AND DANGEROUS
|
Joined: Aug 1999
Posts: 22,200
Member
|
Member
Joined: Aug 1999
Posts: 22,200 |
We have not yet been able to reproduce this issue.
Marco Kalter Allround Automations
|
|
|
|
|
|