Hello!
I'm new in spatial oracle but I really want to learn.
I have a table calle RegionC where I have the coordenates of all the regions in Italy and each region has a number GRUPO. I divided Italy in 5 GRUPO (grups) so now I want the coordenates of each GRUPO with all the regions in it, I mean the coordenates of the hole GRUPO.
That's why I used SDO_UNION, but I gives me nothing!!!
What am I doing wrong?
Please help me!!!!
SELECT SDO_GEOM.SDO_UNION(a.geom, m.diminfo, c.geom, m.diminfo)
FROM scott.regionc a, scott.regionc c, user_sdo_geom_metadata m
WHERE m.table_name = 'SCOTT.REGIONC' AND m.column_name = 'GEOM'
AND a.grupo = 3;
SELECT SDO_GEOM.SDO_UNION(a.geom, c.geom, 0.5)
FROM scott.regionc a, scott.regionc c, user_sdo_geom_metadata m
WHERE m.table_name = 'SCOTT.REGIONC' AND m.column_name = 'GEOM'
AND a.grupo = 3;
I've also tried this:
select sdo_aggr_union(sdoaggrtype(c.geom,0.5))
from scott.regionc c
where c.grupo=3;
ERREUR à la ligne 2 :
ORA-03113: fin de fichier sur canal de communication
select sdo_aggr_union(sdoaggrtype(c.geom,0.5))
from scott.regionc c
group by grupo;
ERREUR à la ligne 1 :
ORA-29913: erreur d'exécution de l'appel ODCIAGGREGATEMERGE
select grupo,sdo_aggr_union(sdoaggrtype(c.geom,0.5))
from scott.regionc c
group by grupo;
ERREUR à la ligne 1 :
ORA-29913: erreur d'exécution de l'appel ODCIAGGREGATEMERGE
Thank you very much in advance!!!
Partager