Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

cannot view geometry on sql developer map viewer

InfoDocOct 1 2020

all of these statements cannot be viewed on map view
(error: "only 2d polygon shapes supported"

select sdo_geometry( 'POINT (-87.4627227 38.12164651)', 4269) from dual;

SELECT SDO_GEOMETRY('POINT(-79 37)') FROM DUAL;

--2001 = 2D, no measures, point
select SDO_GEOMETRY( 2001, 4269, SDO_POINT_TYPE(-79, 37, null), SDO_ELEM_INFO(1), NULL) from dual;

I am using sql developer 18.4

also the invoke on map viewer is grayed out

am I doing something wrong?

2020_10_01_09_35_13_Oracle_SQL_Developer_INDOTDW_as_DWSTAGE_2.png

Comments
Post Details
Added on Oct 1 2020
0 comments
399 views