SDO_GEOR_ADMIN.upgradeGeoRaster

Format

Note: The SDO_GEOR_ADMIN.upgradeGeoRaster subprogram in SDO_GEOR_ADMIN package is deprecated.

SDO_GEOR_ADMIN.upgradeGeoRaster() RETURN SDO_STRING2_ARRAY;

Description

Checks the GeoRaster system data entries and GeoRaster data for the current schema or for all the schemas in the database, and performs any corrective action as appropriate.

Parameters

None.

Usage Notes

This function performs the same checks as the SDO_GEOR_ADMIN.isUpgradeNeeded function, and it takes the corrective action that is appropriate (if any) for the following errors:

• System data entry error, the RDT name is not unique.

• System data entry error, the RDT/RID pair is not unique.

• System data entry error, the GeoRaster table does not exist.

• System data entry error, the GeoRaster column does not exist.

• System data entry error, the GeoRaster object does not exist.

• The GeoRaster object is non-empty or nonblank, but the RDT does not exist.

• Duplicate GeoRaster objects exist (that is, one or more non-unique combinations of RDT and raster ID).

• There is a non-registered pair of (GeoRaster column, GeoRaster object).

If you execute this procedure as a user with DBA role, then the procedure performs checking and correction in all the schemas in the database. Otherwise, it only performs checking and correction in the current schema.

Examples

The following example checks the GeoRaster system data entries and GeoRaster data for the current schema, and performs any corrective action as appropriate.

DECLARE
  ret SDO_STRING2_ARRAY;
BEGIN
  ret:=sdo_geor_admin.upgradeGeoraster;
  for i in 1..ret.count loop
    dbms_output.put_line(ret(i));
  end loop;
END;
/