RE: TOAD 11.5 upset when dropping domain indexes

Yup, we found this one too, thanks.  It's actually just any old index that'll do it.

From: [email protected] [mailto:[email protected]] On Behalf Of Paul Dziemiela
Sent: Tuesday, April 24, 2012 12:43 PM
To: [email protected]
Subject: [toad] TOAD 11.5 upset when dropping domain indexes


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