|
-
April 13th, 2001, 05:01 AM
#1
Oracle
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|