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!

How to export aggregated geometry to GML

user498892Nov 4 2008 — edited Nov 12 2008

Hi,
I have tried to use TO_GMLGeometry along with sdo_aggr_union and it's failed with following error.

SELECT TO_CHAR(SDO_UTIL.TO_GMLGEOMETRY(sdo_aggr_union(mdsys.sdoaggrtype(aggr_geom,0.5)))) aggr_geom
*
ERROR at line 1:
ORA-13378: invalid index for element to be extracted
ORA-06512: at "MDSYS.SDO_UTIL", line 50
ORA-06512: at "MDSYS.SDO_UTIL", line 77
ORA-06512: at "MDSYS.SDO_UTIL", line 1539

I could guess some extent, TO_GMLGEOMETRY won't won't work on SDOAGGRTYPE objects. so, any tips or functions..?

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 10 2008

Added on Nov 4 2008

#database-key-features, #spatial

8 comments

746 views