TOAD 11.5 upset when dropping domain indexes
Paul Dziemiela <[email protected]>
| Newsgroups | gmane.comp.db.oracle.toad.free |
|---|---|
| Message-ID | <93E6FC4F2C85054AA824949283899D2EB191BCC7AB@HW3SP-EXCHQ1.induscorp.com> |
Hi folks,
If I create a simple table with a spatial domain index:
CREATE TABLE foo(
yada NUMBER,
shape MDSYS.SDO_GEOMETRY
);
INSERT INTO user_sdo_geom_metadata(
table_name,
column_name,
diminfo,
srid
) VALUES (
'FOO',
'SHAPE',
MDSYS.SDO_DIM_ARRAY(
MDSYS.SDO_DIM_ELEMENT('X',-180,180,.05),
MDSYS.SDO_DIM_ELEMENT('Y',-90,90,.05)
),
8265
);
COMMIT;
CREATE INDEX foo_spx ON foo(shape)
INDEXTYPE IS MDSYS.SPATIAL_INDEX;
Then open that table in the 11.5 schema browser and drop the table, I receive the error "Could not convert variant of type (Null) into type (OleStr)." I can send along a eureka log but the problems seems easily reproducible. The index is dropped after I clear the error message.
Cheers,
Paul