I guess you are adding a new record to the table ? If so the problem is that you need to enter a unique value into the column MI_PRINX. The best solution would of course be to add a trigger in the Oracle database, that using a Sequence will update this column for you.
This is one of the few things that should be fixed to make the interoperability between MapInfo and Oracle better. Peter Horsbøll Møller GIS Developer, MTM Geographical Information & IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Monday, April 17, 2006 3:15 AM To: mapinfo-l@lists.directionsmag.com Subject: [MI-L] MapInfo Pro - Oracle Spatial Dear Everyone, I have tried to store spatial data into Oracle Spatial database and it worked. But when I try to open it from MapInfo Professional and make editing and draw some new object into the layer then I save it, the error occur explain that the MI_PRINX value is not unique. Could anybody help me please, how to solve this problem. Thank you. Regards, Alit _______________________________________________ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
