What versions of Easyloader and Oracle are you using? EasyLoader: 6.70.08 Oracle 9i (9.0.1.1.1 and up) and 8i (8.1.7)
I have not had any problems loading Float or decimal. I don't have time, but you should look up the Ora error number for more details. You dialog below indicates that you select multiple TABs. Are you loading all the TABs into a single Oracle table? If so I would suspect one of your tab files has the right column name but not the right column datatype. The error seems to indicate that the datatype being passed is not of the expected datatype. It may look like a float or decimal but in fact you may be trying to pass a character string? I would recommend you inspect the data structure of all the import files carefully. If they are to go into a single Oracle table they MUST be identical in structure. Next test for bad data values (out of range). Consider the order of the load. The first table will define the data structure. You might load one file at a time into separate tables to find which TAB file is creating the problem. PS. If you are loading multiple TAB files into a single table TURN OFF index creation. Create the indexes after all loads are complete, this will save time. If you want you can load the last TAB file as a single run and create the indexes then to simplify (I prefer to create my indexes afterward in Oracle using SQL statements. The advantage is I can perform several query tests and tune the indexes in the process. -----Original Message----- From: Yuri Kruglov [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 05, 2003 03:49 AM To: [EMAIL PROTECTED] Subject: MI-L EasyLoader eroor while loading tables to Oracle Spatial Hi, All, I have the fololowing problem while attempting to load TAB files to Oracle Spayial. I do the following. I connect to Oracle Spatial, then select necessary tables, then press Upload Tables. If TAB table contains columns with the datatype of Float or Decimal all operation going failed with the message ORA-01722 Wrong Number "2.003", for example. How do I resolve this problem? Sincerely, Yuri Kruglov --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 7885
