Results for “sdo_georaster”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
The MDSYS.SDO_GEOR_UTL package is a utility package within the Oracle Spatial GeoRaster component. In the context of Oracle E-Business Suite 12.1.1 and 12.2.2, it provides the supporting infrastructure that allows the EBS database tier to store, register, manage, and report on raster imagery referenced by Oracle Spatial. Although GeoRaster is not itself a core EBS application module, the package resides in the shared database environment and is available to any EBS schema granted execute privileges on it. Its primary business role is administrative: it supports the registration of GeoRaster objects into the data dictionary, creation of DML triggers over GeoRaster tables, maintenance of the raster data table (RDT) naming conventions, computation of raster storage characteristics, and generation of status and progress reporting used by long-running raster operations. The package is marked VALID and depends on foundational MDSYS types such as SDO_GEORASTER, SDO_NUMBER_ARRAY, SDO_STRING2_ARRAY, and SDO_STRING2_ARRAYSET.
Key Procedures and Functions
The ETRM metadata documents twenty callable subprograms, reflecting both administrative and reporting responsibilities.
- CREATEDMLTRIGGER and RECREATEDMLTRIGGERS — create and refresh DML triggers that keep GeoRaster metadata synchronized when raster tables are modified.
- RENAMERDT and MAKERDTNAMESUNIQUE — manage raster data table naming, ensuring uniqueness and supporting renaming operations.
- CALCRASTERNOMINALSIZE, CALCRASTERSTORAGESIZE, and CALCOPTIMIZEDBLOCKSIZE — calculate nominal raster dimensions, physical storage consumption, and optimal block sizing for storage planning.
- FILLEMPTYBLOCKS and EMPTYBLOCKS — identify and populate empty raster blocks to maintain storage integrity.
- CREATEREPORTTABLE, DROPREPORTTABLE, and CLEARREPORTTABLE — manage the report table used to capture processing status.
- ISREPORTING, ENABLEREPORT, and DISABLEREPORT — toggle and query reporting state.
- SETSEQID and SETCLIENTID — establish session identifiers used to correlate progress records.
- GETPROGRESS, GETSTATUSREPORT, and GETALLSTATUSREPORT — retrieve progress and consolidated status information for running or completed raster operations.
Tables Accessed
The package references several tables, generally through APPS synonyms. DUAL supports scalar evaluation; USER_TABLES is queried to verify table existence during trigger and report table management; DBMS_LOCK provides serialization for concurrent operations; PLITBLM is used for PL/SQL index-by table buffering; and XMLTYPE supports structured status output. These accesses underpin the administrative, locking, and reporting functions described above.
Usage Notes
In EBS 12.1.1 and 12.2.2, SDO_GEOR_UTL is not typically invoked directly by standard EBS forms or concurrent programs. It is instead called by other MDSYS packages such as SDO_GEOR_ADMIN and by custom PL/SQL code that implements imagery ingestion, GeoRaster registration, or raster maintenance. The package is referenced by one other package and is exposed to PUBLIC. Administrators may invoke its reporting subprograms to monitor progress during large raster loads, while developers embedding GeoRaster in custom extensions rely on its DML trigger and storage-sizing utilities to keep metadata consistent and storage efficient.
-
TYPE: MDSYS.SDO_GEORASTER 12.1.1
-
TYPE: MDSYS.SDO_GEORASTER 12.2.2
-
PACKAGE: MDSYS.SDO_GEOR_UTL 12.1.1
-
PACKAGE: MDSYS.SDO_GEOR_UTL 12.2.2
-
12.1.1 DBA Data 12.1.1
-
12.2.2 DBA Data 12.2.2
-
PACKAGE: MDSYS.SDO_GEOR_UTL 12.1.1
-
PACKAGE: MDSYS.SDO_GEOR_UTL 12.2.2
-
PACKAGE: MDSYS.SDO_GEOR_RA 12.1.1
-
PACKAGE: MDSYS.SDO_GEOR_RA 12.2.2
-
PACKAGE: MDSYS.SDO_TIN_PKG 12.2.2
-
PACKAGE: MDSYS.SDO_TIN_PKG 12.1.1