Search Results is_geodetic




Overview
Explore in AI Chat

Overview

MDSYS.MDPRVT_SRID is an Oracle Spatial utility package owned by the MDSYS schema. It provides internal support for resolving and validating Spatial Reference Identifier (SRID) metadata — the coordinate system definitions used by Oracle's geometry engine to interpret spatial data. Within an Oracle EBS 12.1.1 or 12.2.2 environment, the package operates below the application layer as part of the Oracle Spatial option installed with the database, rather than as an EBS-owned object. Its API classification in the ETRM repository is "OTHER," reflecting that it is not part of the standard EBS business API set but is relied upon by other Oracle-supplied code. The package is referenced by 16 other packages, confirming its role as a low-level dependency for spatial reference lookups rather than a directly callable business service. The user search term "get_unit" corresponds to the most prominent member of this package, the overloaded GET_UNIT function family.

Key Procedures and Functions

  • SDO_INVALIDATE_SRID_METADATA — Invalidates cached SRID metadata for a given SRID and optional SRID type, forcing subsequent lookups to refresh their definitions. It carries a PRAGMA RESTRICT_REFERENCES declaring purity constraints.
  • GET_UNIT — An overloaded function returning unit-of-measure information for a given SRID and optional SRID type. Three overloads exist: one returning a single unit, one returning separate X and Y units, and one returning X, Y, and Z units. Each overload supplies unit identifier, conversion factor, and unit name through OUT parameters. The unit name formal is explicitly constrained to VARCHAR2(80). All overloads are declared DETERMINISTIC PARALLEL_ENABLE.
  • IS_GEODETIC — Determines whether the specified SRID represents a geodetic (ellipsoidal) coordinate system rather than a projected coordinate system. It is DETERMINISTIC PARALLEL_ENABLE with a purity pragma.
  • GET_DIMS — Returns the number of dimensions associated with the specified SRID, such as two for X/Y or three for X/Y/Z geometries.
  • GET_REF_KIND — Returns the reference kind classification for the specified SRID, indicating the nature of the reference system in use.

Tables Accessed

The ETRM metadata documents no tables referenced through APPS synonyms for this package. As an MDSYS-owned Spatial component, MDPRVT_SRID derives its SRID information from Oracle Spatial's own repository objects, including the spatial reference system metadata maintained in the MDSYS schema. Because it is accessed via database-level Spatial structures and not via APPS synonyms, no EBS application tables are read or written, and the package does not participate in the EBS data model directly.

Usage Notes

MDPRVT_SRID is not intended for direct invocation from EBS forms or concurrent programs. It is an internal support package invoked by Oracle Spatial and by the 16 dependent packages identified in the ETRM repository whenever spatial unit and coordinate system metadata must be resolved. Custom applications performing spatial operations, such as geometry validation, coordinate conversion, or SRID-based unit checks, may encounter it indirectly through higher-level Oracle Spatial APIs. Because GET_UNIT and the other functions are declared DETERMINISTIC and PARALLEL_ENABLE, they are safe for use within parallel SQL execution plans and repeated expressions. Any customization that references MDPRVT_SRID directly should be treated as unsupported, since its definition is controlled by Oracle and may change between 12.1.1 and 12.2.2 database releases.