Hi,
I am having the ORA-13050: unable to construct spatial object error when running the following query:
Create table FAB.DOSSIER_E_GEOMETRIE_TMP NOLOGGING as
select
d.*
, 'TEK' "BRON"
, (select sum( round(mdsys.sdo_geom.sdo_area(tek.geometrie, 0.005), 2) )
from VRO.TEKENING tek, vro.DOSSIERTEKENING dt
WHERE dt.TEKENING_ID = tek.id
and dt.DOSSIER_ID = D.DOSSIER_ID
and DT.DATUMAFVOER is null
and tek.DATUMAFVOER is null
group by dossier_id) "OPPERVLAK_GEOM"
, (select SDO_AGGR_UNION(MDSYS.SDOAGGRTYPE(GEOMETRIE, 0.001))
from VRO.TEKENING tek, vro.DOSSIERTEKENING dt
WHERE dt.TEKENING_ID = tek.id
and dt.DOSSIER_ID = D.DOSSIER_ID
and DT.DATUMAFVOER is null
and tek.DATUMAFVOER is null
and tek.NIVEAU = 0
group by dossier_id) "GEOMETRIE"
from vro.dossier d
where D.STATUS <> 'H'
and D.DOSSIERLETTER in ('E','EW')
and d.DOSSIER_ID in (select DOSSIER_ID from vro.dossiertekening dt2, vro.tekening tek
where dt2.DOSSIER_ID = d.DOSSIER_ID
and dt2.DATUMAFVOER is null and dt2.TEKENING_ID = tek.ID and tek.DATUMAFVOER is null)
The query was made by people who worked before me. There is no documentation. It should create a table and fill with data. It had been running fine but stopped working suddenly. What could be the issue?