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
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.