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;
/