Posted: Thu May 31, 2012 4:15 am Post subject: Decimal Separator Problem (ORA-01747)
I hope, anyone has an idea where my config problem is. I think, I tried nearly everything without success.
Following problem: I want to load data from DB2/400 Database to an Oracle 10g (Express Edition) Database. A direct load is no problem, but with TableComparision I get the ORA-01747 error when there is an update record.
The error log shows following Update-Statement:
Update "SCHEMA"."TABLE_A" SET "ID" = 1,0000000, "NR2" = 19303,0000000, "NAME" = 'New Name'
WHERE "ID" = 1,0000000 and "NR2" = 19303,0000000 and "NAME" = 'Old Name';
The problem is the comma (,) in the numeric value. I've found no way to replace them by a point (.) as separator.
If I execute the statement on the Database as shown above, I get the same error. If I correct the decimal separator as point, the sql works perfect.
The Language in the Datastore-config is eng (Englisch), Code page = <default>, and Server code page = <default>.
Posted: Thu May 31, 2012 6:41 pm Post subject: Re: Decimal Separator Problem (ORA-01747)
I think you have a mismatch of the regional settings between the client (where the job server resides) and the database server. If you are on Windows this may be found in Programs->Settings->Control Panel->Regional and Language options. I could be wrong on how to change it as I don't deal with settings other than U.S.