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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Spatial - ORA-13050: unable to construct spatial object

Jim JonesApr 25 2024

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 /*+ FIRST_ROWS(10) INDEX(d PK_DOSSIER) */
         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
                  --and tek.NIVEAU = 0
                  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?

Comments

Post Details

Added on Apr 25 2024
2 comments
243 views