Search Results sdo_csw_process




Overview
Explore in AI Chat

Overview

The MDSYS.SDO_CSW_PROCESS package is an Oracle Spatial catalog services for the Web (CSW) processing unit shipped with the MDSYS schema and exposed to Oracle E-Business Suite 12.1.1 and 12.2.2 through the database dictionary. It is declared with AUTHID current_user, meaning it executes with the privileges of the invoking schema rather than the definer, which allows EBS application schemas such as APPS to reference it safely without elevated MDSYS rights. Its business role is to manage the metadata, record-type mappings, and spatial path resolution logic that underpin CSW-based discovery of spatially enabled records. EBS deployments that register spatial data sources, publish geo-referenced content, or integrate with external spatial catalogs rely on this package to bind XML record-type definitions, plugin packages, domain information, and record-view maps to the underlying spatial tables.

Key Procedures and Functions

  • SORTSPCONTENTBYCOLINDEX — reorders spatial path content according to a column index, returning a geometry path info structure.
  • GENSPATIALPATHELEMCOLINDEX — generates the column index for a single spatial path element.
  • GENIDVALUE — derives an identifier value from an XMLType record given namespace, type name, and user context.
  • GETPATH and GETPARSEDPATH — serialize and parse spatial paths into and out of a StringList representation (namespace, name pairs).
  • GENRECORDTYPEPROCESSINGLOGIC — constructs the processing logic for a registered record type.
  • ISROWIDIN — determines whether a ROWID appears in a supplied RowPointerList.
  • INSERTRTMDUPDATED and INSERTRTDATAUPDATED — record metadata and data update timestamps for record types.
  • INSERTCAPABILITIESINFO and DELETECAPABILITIESINFO — maintain the CSW capabilities document.
  • GETRECORDTYPEID — resolves a record type identifier from namespace URL and name.
  • INSERTPLUGINMAP and DELETEPLUGINMAP — manage the mapping of record types to handler plugin packages.
  • INSERTDOMAININFO and DELETEDOMAININFO — manage domain parameter values associated with a record type.
  • INSERTRECORDVIEWMAP and DELETERECORDVIEWMAP — maintain view-to-record-type mapping definitions with XMLTYPE map information.
  • EXTRACTID and PROCESSIDPATH — extract and process identifier paths, completing the 58 documented program units.

Tables Accessed

The package references XMLTYPE for parsing and constructing record-type and map definitions, ALL_VIEWS for resolving the views that expose record content, DBMS_OUTPUT for diagnostic messaging, DUAL for single-row evaluations, and PLITBLM, the PL/SQL table supporting the StringList and RowPointerList collection types used throughout the API. These accesses are performed through APPS synonyms, so EBS schemas reach the MDSYS objects without direct grants.

Usage Notes

SDO_CSW_PROCESS is not a form-invoked API. It is typically called from spatial catalog configuration routines, concurrent programs that refresh CSW capabilities and record-type metadata, and custom PL/SQL integrations that register spatial data sources. Because the package is AUTHID current_user, callers must hold execute privileges and any necessary object privileges on the referenced tables. The searched term "sds page electrophoresis" is unrelated to this object; SDS-PAGE is a laboratory technique, and this package serves Oracle Spatial CSW metadata processing, not scientific computing. No EBS package is documented as referencing SDO_CSW_PROCESS, so it should be treated as a standalone MDSYS utility invoked directly by custom code or spatial catalog administration.