Print Thread
THIS IS FRUSTRATING AND DANGEROUS
#37648 03/19/10 03:17 PM
Joined: Mar 2007
Posts: 147
Zagreb, Croatia
DoDo Offline OP
Member
OP Offline
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
DoDo #37660 03/22/10 11:56 AM
Joined: Aug 1999
Posts: 22,153
Member
Offline
Member
Joined: Aug 1999
Posts: 22,153
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
Marco Kalter #37664 03/22/10 12:22 PM
Joined: Mar 2007
Posts: 147
Zagreb, Croatia
DoDo Offline OP
Member
OP Offline
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
DoDo #37675 03/23/10 10:16 AM
Joined: Aug 1999
Posts: 22,153
Member
Offline
Member
Joined: Aug 1999
Posts: 22,153
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
Marco Kalter #37704 03/25/10 11:54 AM
Joined: Mar 2007
Posts: 147
Zagreb, Croatia
DoDo Offline OP
Member
OP Offline
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
DoDo #37720 03/30/10 09:06 AM
Joined: Mar 2007
Posts: 147
Zagreb, Croatia
DoDo Offline OP
Member
OP Offline
Member
Joined: Mar 2007
Posts: 147
Zagreb, Croatia
Any news Marco?


DoDo
--------------------------------------------
Be happy, tomorrow it can become only worse. If not, even better!
Re: THIS IS FRUSTRATING AND DANGEROUS
DoDo #37722 03/30/10 09:24 AM
Joined: Aug 1999
Posts: 22,153
Member
Offline
Member
Joined: Aug 1999
Posts: 22,153
We have not yet been able to reproduce this issue.


Marco Kalter
Allround Automations

Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.038s Queries: 15 (0.012s) Memory: 2.5222 MB (Peak: 3.0394 MB) Data Comp: Off Server Time: 2024-03-19 11:47:04 UTC
Valid HTML 5 and Valid CSS