Problem with decimal numbers

From: Michael Brohl <michael.brohl_at_t-online.de>
Date: 1998/05/28
Message-ID: <6kk4hu$cks$1@news01.btx.dtag.de>#1/1

Hello,

I've got a problem with the conversion of decimal numbers:

On my Personal Oracle Database, the command

TO_CHAR(TO_NUMBER('1.0')) works properly, the command

TO_CHAR(TO_NUMBER('1,0')) does not.

On an Oracle Database 7.3.2.2.1, it's vice versa. My procedures I developed doesn't run on this database.

Does anyone know on which Database parameters this behaviour depends and how I can change them? The windows country parameters are always the same, german in this case.

Any help and hints were appreciated.

Bye

Michael

-- 
     Fido: 2:2449/480.3
    Email: michael.brohl_at_usa.net
 Homepage: http://home.t-online.de/home/michael.brohl

Received on Thu May 28 1998 - 00:00:00 CDT