I have a Oracle Spatial table defined as follow:
CREATE TABLE foo ( id NUMBER(9) PRIMARY KEY, sdo SDO_GEOMETRY NOT NULL);And a view defined like this:
CREATE VIEW bar AS SELECT * FROM fooWhen I try to open foo in MapInfo 11.5 (by clicking File -> Open, and selecting my Oracle Spatial connection in the file dialog) it works just as expected. However, when I try to open bar I get the following error message (translated from Swedish by me):
أكثر...
CREATE TABLE foo ( id NUMBER(9) PRIMARY KEY, sdo SDO_GEOMETRY NOT NULL);And a view defined like this:
CREATE VIEW bar AS SELECT * FROM fooWhen I try to open foo in MapInfo 11.5 (by clicking File -> Open, and selecting my Oracle Spatial connection in the file dialog) it works just as expected. However, when I try to open bar I get the following error message (translated from Swedish by me):
Invalid conversion of data type. Could not fetch posts for table.
In the same way, foo can be made mappable while bar can not. Why is this? Is it impossible to open views in MapInfo?
أكثر...