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

forum.connectivity (2000-2005) & forum.td.connectivity (2005-2010)
Michael Felix

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

Post by Michael Felix » 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

Ales Jeglic

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

Post by Ales Jeglic » 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

Michael Felix

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

Post by Michael Felix » 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] and 0 guests