Hi,
We're trying to add an on-the-fly genereated oracle spatial table into a
MXJ3 application. We are adding an entry into the MapInfo_MapCatalog and
and entry into the USER_SDO_GEOM_METADATA table, but we are unable to load
the new table into MapInfo pro... it gives an unrecognized data type in
field "SHAPE" error.
Has anyone done this successfully? I've included my describe and insert
scripts below, just incase someone has any ideas. Thanks and please reply
to me at [EMAIL PROTECTED]
Thanks,
Chris
INSERT INTO USER_SDO_GEOM_METADATA
VALUES
arket_Folder','shape',MDSYS.SDO_DIM_ARRAY(
MDSYS.SDO_DIM_ELEMENT('X', -180, 180, 0.0000005),
MDSYS.SDO_DIM_ELEMENT('Y', -90, 90, 0.0000005) ),
NULL );
CREATE INDEX MFld_spatial_idx
ON Market_Folder(shape)
INDEXTYPE IS MDSYS.SPATIAL_INDEX
PARAMETERS('SDO_LEVEL = 8');
INSERT INTO MAPINFO_MAPCATALOG
(SPATIALTYPE,
TABLENAME,
OWNERNAME,
SPATIALCOLUMN,
DB_X_LL,
DB_Y_LL,
DB_X_UR,
DB_Y_UR,
COORDINATESYSTEM,
SYMBOL,
XCOLUMNNAME,
YCOLUMNNAME)
VALUES
(13.2,
'Market_Folder',
'VECTIV',
'SHAPE',
-180,
-90,
180,
90,
'Earth Projection 1, 62',
'Pen (1, 2, 0) Brush (2, 12648384, 16777215)',
'NO_COLUMN',
'NO_COLUMN');
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
