34.8 SDO_WCS.ValidateCoverages
Format
SDO_WCS.ValidateCoverages( ) RETURN MDSYS.SDO_WCS_INVALID_COVERAGE;
Description
Validates GeoRaster objects in the WCS metadata tables and returns the coverage IDs of all invalid WCS metadata entries.
Parameters
(None.)
Usage Notes
This procedure must be invoked by a WCS user.
When GeoRaster objects are deleted, references to them might remain in WCS metadata tables. Such references are invalid metadata entries.
This function returns an MDSYS.SDO_WCS_INVALID_COVERAGE object, which is defined as: TABLE OF VARCHAR2(4000)
Each element of the returned object is a coverage Id from the WCS metadata tables in which the corresponding GeoRaster object was not found. Invalid metadata entries are not handled by the DescribeCoverage Operation (WCS) and GetCoverage Operation (WCS).
For information about support for WCS, see Web Coverage Service (WCS) Support.
Examples
The following example iterates over all invalid coverage IDs and unpublishes them, leaving only valid coverages in the WCS metadata.
DECLARE
BEGIN
FOR i IN (select * from table(SDO_WCS.ValidateCoverages()))
LOOP
SDO_WCS.UnpublishCoverage(i.column_value);
END LOOP;
END;
/
Parent topic: SDO_WCS Package (Web Coverage Service)