I am attempting to create a table in Oracle Spatial that can be then be opened in MapInfo, but am struggling to open the table.
I am using SQL*Loader to load point data into my table in Oracle, including a column called geoloc to hold the geometry. I've used SDO_GEOM.VALIDATE_GEOMETRY_WITH_CONTEXT to check that the geometries were successfully created and included a primary key column that contains a unique numeric reference number for each row (called MI_PRINX). I am able to successfully perform queries on my data in Oracle. I am now trying to open this table in MapInfo. I have successfully created a Oracle Spatial DBMS connection to Oracle from MapInfo enabling me to select the spatial table I am trying to open. I then try and open it with Live Access but get the following error message ' Unsupported data type for column(s): GEOLOC ', where GEOLOC is the column in the oracle table that contains the geometry. Does anyone know how to tell MapInfo that this is the geometry and use it to plot the points? Thanks in advance for your help, John John Bark Information Systems Analyst Marks & Spencer * [EMAIL PROTECTED] * www.marks-and-spencer.com ----------------------------------------------------------------------- Registered Office: Marks and Spencer Group and plc Waterside House 35 North Wharf Road London W2 1NW Registered No. 214436 in England and Wales. Telephone (020) 7935 4422 Facsimile (020) 7487 2670 www.marksandspencer.com Please note that electronic mail may be monitored. This e-mail is confidential. If you received it by mistake, please let us know and then delete it from your system; you should not copy, disclose, or distribute its contents to anyone nor act in reliance on this e-mail, as this is prohibited and may be unlawful. The registered office of Marks and Spencer Financial Services PLC, Marks and Spencer Unit Trust Management Limited, Marks and Spencer Life Assurance Limited and Marks and Spencer Savings and Investments Limited is Kings Meadow, Chester, CH99 9FB. These firms are authorised and regulated by the Financial Services Authority.
