Hi MapInfo users,
I'm using Mapinfo 7.0 and EasyLoader 7.0 I want to upload to Oracle Spatial a .tab table with region objects and tabular data structure as follows
Definition Table Type NATIVE Charset "WindowsLatin1" Fields 3 XY_ID Decimal (13, 0) ; AREA Decimal (17, 2) ; DATE_MODIFIED Date ;
I got this error
--------------------------- MapInfo Upload Utility Error --------------------------- TESTUPD, insert failed for row: 1
ORA-01722: invalid number
Data Values: 65544661731 --------------------------- OK ---------------------------
I've now figured out that the problem is with Decimal field with decimal places greater than zero - AREA Decimal (17, 2); in my case.
I haven't find a solution without loss of information, either precision (1) or type information (2) (1) truncate the decimal places (2) change field type to Character
1. What might be the best solution?
2. Why such incompatibility, as my table is just a part of another table, linked from the same oracle database? XY_ID NUMBER (11) AREA NUMBER (15,2) DATE_MODIFIED DATE
3. The error message is unclear - 65544661731 is really a valid number :-)
TIA, Ikker
_________________________________________________________________
Add photos to your messages with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail
--------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 13630
