SDO_RELATE issue
While execution of the following code I am getting error.
create or replace
Procedure UpdateSiteIDInGIS
IS
result number;
BEGIN
FOR develop_site
IN (SELECT asd.site_location
FROM sd_development_sites asd
)
Loop
SELECT ds_id_fk
into result
FROM sd_gis_ds_dom_coverage,sd_development_sites
WHERE sdo_relate(develop_site.site_location,ds_boundary,
'mask=inside') = 'TRUE';
dbms_output.put_line(result);
END LOOP;
END;
error--
ORA-13226: interface not supported without a spatial index
ORA-06512: at "MDSYS.MD", line 1723
ORA-06512: at "MDSYS.MDERR", line 8
ORA-06512: at "MDSYS.SDO_3GL", line 82
ORA-06512: at "DW_SPATIAL_DASH.UPDATESITEIDINGIS", line 15
create or replace
Procedure UpdateSiteIDInGIS
IS
result number;
BEGIN
FOR develop_site
IN (SELECT asd.site_location
FROM sd_development_sites asd
)
Loop
SELECT ds_id_fk
into result
FROM sd_gis_ds_dom_coverage,sd_development_sites
WHERE sdo_relate(develop_site.site_location,ds_boundary,
'mask=inside') = 'TRUE';
dbms_output.put_line(result);
END LOOP;
END;
error--
ORA-13226: interface not supported without a spatial index
ORA-06512: at "MDSYS.MD", line 1723
ORA-06512: at "MDSYS.MDERR", line 8
ORA-06512: at "MDSYS.SDO_3GL", line 82
ORA-06512: at "DW_SPATIAL_DASH.UPDATESITEIDINGIS", line 15
0