CTD 3.0.0 ORA9.2 Problem Fetching or Updating a number value with comma

forum.connectivity (2000-2005) & forum.td.connectivity (2005-2010)
NewsgroupServer
Robot
Robot
Posts: 118939
Joined: 24 Feb 2017, 12:00
Location: World wide

CTD 3.0.0 ORA9.2 Problem Fetching or Updating a number value with comma

Post by NewsgroupServer » 05 Jan 2004, 09:50

 Posted by:  Michael Felix 


Hi,

when I try to fetch or update a field defined as Datatype Number in CTD and
Datatype NUMBER in ORACLE everything works fine as long as I use integers.
When I try to update a field with a number with comma (e.g. 123,12), I get
the message 'ORA-01722: Ungültige Zahl ' (Invalid number)
When I try to fetch a NUMBER field with comma value, I get 'Attempt to fetch
non-numeric data into numeric column. Error Number 104'

I am using Quick Objects

What am I doing wrong?
Any advice appriciated

Michael

NewsgroupServer
Robot
Robot
Posts: 118939
Joined: 24 Feb 2017, 12:00
Location: World wide

CTD 3.0.0 ORA9.2 Problem Fetching or Updating a number value with comma

Post by NewsgroupServer » 07 Jan 2004, 22:45

 Posted by:  Ales Jeglic 


We get same msg with ORA client. Regional setting of client was Slovenian
(in your case Austrian ?).

Error was solved with additional registry entry:

[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME0]
"NLS_NUMERIC_CHARACTERS"=".,"

First char specified is thounsand separator and second is decimal point
which are different for most of Europe regions from default (US English).

I think this can be also done programaticaly from CTD. We prefer registry
because is valid for every connection from ORA client.

Regards,

Ales Jeglic

NewsgroupServer
Robot
Robot
Posts: 118939
Joined: 24 Feb 2017, 12:00
Location: World wide

CTD 3.0.0 ORA9.2 Problem Fetching or Updating a number value with comma

Post by NewsgroupServer » 09 Jan 2004, 23:07

 Posted by:  Michael Felix 

That's it!!

Thanks a lot
Michael

Return to “td.connectivity”

Who is online

Users browsing this forum: Ccbot [Crawler] and 0 guests