Spatial Column Problems with PL/SQL Developer 9

[CTAMike]

BUG: Querying a Spatial column returns "Error while trying to retrieve text for error ORA-21500" in PL/SQL Developer 9.0.6.1665. This worked in PL/SQL Developer 8, it would simply break down the SHAPE field into fields as follows:

SHAPE.SDO_GTYPE
SHAPE.SDO_SRID
SHAPE.SDO_POINT.X
SHAPE.SDO_POINT.Y
SHAPE.SDO_POINT.Z
SHAPE.SDO_ELEM_INFO
SHAPE.SDO_ORDINATES

I also highly suggest working on incoperating GeoRaptor into the PL/SQL Developer engine.
http://sourceforge.net/apps/mediawiki/georaptor/index.php?title=Main_Page

Thanks in advance!

--Mike

 

[Marco Kalter]

Can you send a little script to reproduce this?

 

[CTAMike]

CREATE TABLE BUSOPS_K_ZONES2 (
DIST NUMBER,
REGION VARCHAR2(12),
DIST_TEXT VARCHAR2(5),
SHAPE_AREA NUMBER,
SHAPE_LEN NUMBER,
SHAPE MDSYS.SDO_GEOMETRY);

INSERT INTO USER_SDO_GEOM_METADATA (TABLE_NAME, COLUMN_NAME, DIMINFO, SRID)
VALUES ('BUSOPS_K_ZONES2', 'SHAPE',
MDSYS.SDO_DIM_ARRAY
(MDSYS.SDO_DIM_ELEMENT('X', -88.000000000, -87.000000000, 0.010000000),
MDSYS.SDO_DIM_ELEMENT('Y', 41.500000000, 42.100000000, 0.010000000)
),
8307);
COMMIT;

SELECT * FROM BUSOPS_K_ZONES2; --Fails "Error while trying to retrieve text for error ORA-21500
SELECT DIST, REGION, DIST_TEXT, SHAPE_AREA, SHAPE_LEN
FROM BUSOPS_K_ZONES2; --OK
SELECT SHAPE FROM BUSOPS_K_ZONES2; --Fails "Error while trying to retrieve text for error ORA-21500

 

[Marco Kalter]

This script works fine, but there is no data in the BUSOPS_K_ZONES2 table.