[QGIS-Developer] Oracle spatial compound (2004 SDO_GTYPE collection) objects

[Fabio Fumi]

Hi,



I have "collection" objects (2004 SDO_GTYPE) from an Oracle spatial DB,
that I wish to display using QGis. As far as I understood, this isn’t
possible and I would like a confirmation, or some workaround, if ever
possible.



The following is an example of an object found in my “shape” column:



MDSYS.SDO_GEOMETRY(*2004*, NULL, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1, 2, 1,
5, 2, 1, 9, 2, 1, 13, 2, 1, 17, 2, 1, 21, 2, 1, 25, 2, 1, 29, 1, 2, 33,
1003, 1, 41, 1003, 1), MDSYS.SDO_ORDINATE_ARRAY(700518.829, 5156838.484,
700520.831, 5156822.663, 700516.342, 5156903.685, 700540.45233515,
5156890.95679796, 700505.811693905, 5156881.54926549, 700516.297,
5156888.439,  [ . . . ]



Trying to add this as a layer results in an error like:



“Tipo geometria e SR non definiti per la colonna vuota SHAPE” (translated:
“undefind geomeotry type and SR for the empty SHAPE column”)



I also tried downloading latest 3.12.3 release, as I read in the change
logs there was an added support for “Oracle compound polygon”, but I guess
that wasn’t exactly what I needed.



Thanks for any help

Fabio (Rome – Italy)
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20200527/911bb4fd/attachment.html>