Results for “sdo_geor”

50+ results




AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

MDSYS.SDO_GEOR is the Oracle Spatial GeoRaster PL/SQL package body, the implementation layer behind the SDO_GEOR specification shipped with the Oracle Database. Within an Oracle E-Business Suite 12.1.1 or 12.2.2 environment, it provides the server-side engine that application code, database objects, and custom extensions use to store, manage, and process raster imagery natively inside the database. GeoRaster data is held in SDO_GEORASTER objects, with cell data persisted in relational tables and metadata maintained in XML. The package body is owned by MDSYS, carries an ETRM status of VALID, and is classified under the API category OTHER, reflecting that it is a platform-supplied spatial utility rather than an EBS application-facing API.

The business function is the manipulation of georeferenced raster data used by EBS modules and custom solutions that depend on imagery, such as mapping, asset visualization, land management, and spatial analytics layered on the Oracle Spatial stack. The searched term sdo_geor_colormap corresponds to the SDO_GEOR_COLORMAP type referenced by this package, which underpins operations that attach, read, or apply color mapping to raster data.

Key Procedures and Functions

The package body exposes 204 documented procedures and functions. Representative members include:

  • INIT — initializes a GeoRaster object with the required dimensional and metadata characteristics.
  • CREATEBLANK — creates an empty GeoRaster object as a container for subsequent loading or generation.
  • COPY — produces a duplicate of an existing GeoRaster object.
  • CHANGEFORMAT and CHANGEFORMATCOPY — convert raster cell representation between formats, in place or into a copy.
  • MASK — applies a mask operation to raster cell data.
  • SUBSET — extracts a defined portion of a raster.
  • SCALE and SCALECOPY — rescale raster values, in place or into a copy.
  • GENERATEPYRAMID and DELETEPYRAMID — build or remove pyramid levels used to accelerate multi-resolution retrieval.
  • GENERATESPATIALEXTENT — computes and records the spatial footprint of a raster.
  • MOSAIC and VALIDATEFORMOSAIC — assemble multiple rasters into a mosaic and validate them for that purpose.
  • MERGELAYERS — combines raster layers into a single layer.
  • UPDATERASTER — writes or refreshes raster cell data.
  • CREATETEMPLATE — produces a reusable GeoRaster template.
  • GETRASTERBLOCKLOCATOR, GETRASTERRANGE, and VALIDATEBLOCKMBR — return block location, value range, and validate block minimum bounding rectangles.

Tables Accessed

The ETRM metadata records references through APPS synonyms to DBMS_LOB, DBMS_OUTPUT, DUAL, PLITBLM, and XMLTYPE. GeoRaster cell data and metadata are not stored in fixed application tables; they reside in user-defined GeoRaster tables (SDO_GEORASTER columns plus associated raster data tables) supplied by the implementer. DBMS_LOB and XMLTYPE are used because binary cell blocks are stored as large objects and metadata is held as XML, while DUAL and PLITBLM support internal PL/SQL processing. The package body also depends on MDSYS objects including SDO_GEORASTER, SDO_GEOR_METADATA, SDO_GEOR_SRS, SDO_GEOR_COLORMAP, SDO_GEOR_GRAYSCALE, SDO_GEOR_HISTOGRAM, SDO_GEOR_GCP and its collection type, and supporting types such as SDO_GEOMETRY and SDO_RANGE_ARRAY.

Usage Notes

SDO_GEOR is invoked from PL/SQL — directly in custom database code and spatial routines, and indirectly from EBS forms or concurrent programs that call GeoRaster operations. It is referenced by six other database packages, so its routines are commonly reached through higher-level spatial wrappers rather than called directly. Typical invocations occur during raster loading, format conversion, mosaicking, pyramid generation, and metadata maintenance. Because the object belongs to MDSYS, EBS customizations should call it through public synonyms and avoid modifications. In release 12.2.2 the full 204-member API surface is documented and VALID, confirming availability across supported EBS 12.1.1 and 12.2.2 installations that include Oracle Spatial.