Not showing spatial information from result grid

[oyvind.eide]

When I do a query against a table containing a MDSYS.SDO_GEOMETRY column (Oracle Spatial), the information from the geometry object is devided into 7 columns, which is OK. But when I press the ... button of a field in the SDO_ELEM_INFO or SDO_ORDINATES column, the error message

"Collection no longer available.
Execute the SQL Script again to fetch the collection again."

always appears. Doing the search again does not help.

The database version is 9.2.0.6 on Solaris and the PLSQL Developer is 6.0.4.906 on Win 2k.

Kind regards

 

[Marco Kalter]

This seems like a bug. We'll fix it.

 

[oyvind.eide]

We have found out that using a different syntax in the search helps. Both of these reproduces the bug:

select t.* from n50_adminf t
select t.geom from n50_adminf t

(geom is the spatial column of the table n50_adminf)

But this search gives a result where the ... works fine:

select t.geom.sdo_elem_info, t.geom.sdo_ordinates from n50_adminf t

Regards,