Oracle

[HoBro]

I have a problem with inserting data into oracle from AS400. When I read the data from the AS400 and generate the INSERT Statement for Oracle it looks like this :

INSERT INTO CS_ClientFund () VALUES ( 100, 'NEVE05', 'Portfolio xxx', '0.0000000', '0.0000000', '0.0000000', '5795704', '42119', 'N')

But when I try to execute it - Oracle throws an Error : "invalid number", because the right syntax for "0.0000000" should be "0,0000000". Does anybody know how to change it without changing the program itself. I've tried to change the regional settings but I had no luck. Maybe the language settings of the Oracle client must be changed, but I don't know how. Can anybody give me some advice ??? Thanks for your time !

HoBro

[Iouri]

IN your SQL instead of
'0.0000000'
try to use
Replace("0.0000000", ".", ",")

Iouri Boutchkine
[email protected]

[HoBro]

I can't modify the program itself, because there are about 40 clients who use this program and they don't have the problem at all. I've installed Win 2000 on my machine last week and since that time it doesn't work anymore. There have to be some settings in the ORA Client or Win2000, which have to be changed, but I can't figure it out. But anyway, thanks for your help !

HoBro

[Cimperiali]

Make a try:
You should be able to change regional setting on win2000 (settings...Control Panel...Regional Settings -in win 98- or maybe International Option in win2000) for numer and date....



Special thanks to Lothar "the Great" Haensler. Come back soon, you Guru.