Format

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