Search Results prvt_idx




Overview
Explore in AI Chat

Overview

MDSYS.PRVT_IDX is a private PL/SQL package body within the Oracle Spatial and Graph subsystem, owned by the MDSYS schema. In the context of Oracle E-Business Suite 12.1.1 and 12.2.2, this package supports spatial indexing operations that underpin geographic and location-aware data processing used by applications such as Oracle Field Service, property management modules, and any custom extensions that store SDO_GEOMETRY columns. The object is not an EBS product schema object; rather, it is a database-level component shipped with the Oracle Spatial option and referenced indirectly by EBS data models that rely on spatial datatypes.

The package body is classified as VALID, indicating it compiles successfully and is available at runtime. Its API classification is OTHER, reflecting that it exposes no public application programming interface and is intended strictly for internal use by the Spatial framework. Because PRVT_IDX is a package body without a corresponding specification in the ETRM record, its procedures and functions are not externally callable and should be regarded as implementation detail rather than an integration surface.

Key Procedures and Functions

The ETRM metadata documents zero procedures or functions for MDSYS.PRVT_IDX. This is consistent with the package's private nature: it contains internal helpers invoked by the Spatial index type implementations rather than named entry points exposed to callers. No parameter lists are documented, and none should be assumed.

  • Index maintenance handlers that support the domain index type SDO_INDEX_METHOD_10I.
  • Helper routines used by the index library ORDMD_IDX_LIBS during create, alter, and drop index operations.
  • Internal geometry access utilities operating against SDO_GEOMETRY and ST_GEOMETRY types.
  • Support logic invoked from MDPRVT_IDX and PRVT_IDX itself through recursive or internal references.

These are functional roles inferred from the documented dependency set, not formally enumerated procedures.

Tables Accessed

The documented table references are ALL_OBJECTS, ODCICONST, and PLITBLM, all reached through APPS synonyms. ALL_OBJECTS provides data dictionary metadata used for dependency resolution and object validation. ODCICONST defines the Oracle Data Cartridge interface constants that the index routines rely on when implementing the extensible indexing contract. PLITBLM supplies PL/SQL internal table buffering support, enabling efficient in-memory manipulation of index metadata during DDL and DML operations on spatial indexes. The package additionally depends on SDO_UTIL, DBMS_ASSERT, STANDARD, and MDERR, indicating use of geometry utilities, identifier validation, and the standard error-raising framework.

Usage Notes

PRVT_IDX is never invoked directly by EBS forms, concurrent programs, or custom code. It is executed implicitly whenever the database performs operations on spatial indexes built with SDO_INDEX_METHOD_10I, including index creation during patching, index rebuilds during upgrades from 12.1.1 to 12.2.2, and query execution that leverages spatial operators. The ETRM record shows the package is referenced by 16 other packages, confirming its role as shared supporting infrastructure rather than an entry point.

Administrators should not modify or recompile this package. Custom EBS development that manipulates spatial data should target documented public APIs such as SDO_UTIL and the Spatial operators, leaving PRVT_IDX to the framework. Any tuning of spatial index behavior should be directed through the supported index parameters and DDL, not through this private body.