Search Results unset_section_attribute




Overview
Explore in AI Chat

Overview

CTXSYS.DRISGP is the Oracle Text Section Group management package that ships with the Oracle Text (interMedia/CTXSYS) option and is registered in Oracle E-Business Suite 12.1.1 and 12.2.2 as an externally owned API classified as OTHER. It provides a programmatic interface for defining, populating, copying, and dropping the section groups that govern how a text index is subdivided into named, addressable regions. In an EBS context this matters because Oracle Text indexes are used by products such as Oracle Knowledge Management, iStore/Advanced Search, and Oracle iRecruitment, all of which store documents, attachments, and short text fields inside the database and rely on section-aware indexing to enable field-restricted and within-section querying.

The package declares a large set of constants that identify section types (zone, field, special, stop, attribute, XML, metadata, sensitivity and normal data) and the data types permitted inside each section type, together with the FID ranges that reserve identifier space for each section category. These constants are the vocabulary through which custom code and Oracle Text itself interact with a section group definition.

Key Procedures and Functions

The documented interface contains 33 procedures and functions, of which the following are representative:

  • CREATE_SECTION_GROUP — defines a new, empty section group with a name and group type, optionally controlling implicit commit behaviour.
  • DROP_SECTION_GROUP — removes an existing section group definition.
  • SET_SEC_GRP_ATTR — the routine the user searched for; it sets a named attribute on an existing section group, adjusting its indexing behaviour after creation.
  • INS_SEC_GRP_ATTR_BY_ID — inserts a section-group attribute using an internal identifier rather than a name.
  • ADD_SEC_GRP_ATTR_VAL / REM_SEC_GRP_ATTR_VAL / UNSET_SEC_GRP_ATTR — add, remove, or clear individual attribute values associated with a section group.
  • ADD_SECTION / REMOVE_SECTION — add or remove a section within a group; ADD_SECTION also has an INDEXADDSECTION counterpart used during indexing.
  • GET_DEFAULT_SECTION / GET_SG_INFO / GETSECTION / GETSECTIONS / HASSECTIONTYPE — introspection routines that return default section names, group metadata, individual sections, all sections, and type membership tests.
  • COPY_SECTION_GROUP / DROP_USER_SECTION_GROUPS — duplicate an existing definition or bulk-remove user-defined groups.
  • LOADSECTIONMD / FIELD_TO_MDATA / INDEXREMSECTION — supporting routines that load section metadata, map a field into metadata storage, and remove a section during indexing.

Tables Accessed

The only documented base table referenced through an APPS synonym is PLITBLM, the Oracle Text (interMedia) internal support table. DRISGP uses it to persist section-group definitions and the attribute overrides applied through SET_SEC_GRP_ATTR and the related attribute routines. The package additionally reads and writes the CTXSYS catalog views that expose the DR$ section-group dictionary, which is why it must be invoked with sufficient privileges on the CTXSYS schema or through a synonym granted to APPS.

Usage Notes

CTXSYS.DRISGP is an internal Oracle Text API rather than an EBS business API; it is not surfaced through an EBS form or standard concurrent program. In practice it is invoked from custom PL/SQL during text-index provisioning, from database setup scripts that build section-aware indexes for a custom application, or from DBA maintenance scripts that adjust or drop section groups when an index is rebuilt. It is referenced by 18 other Oracle Text packages, so direct calls should be treated as privileged operations. Because the package performs DDL-like operations on the text catalog, changes should be made in a controlled window and followed by an index rebuild or synchronisation in the owning Oracle Text index.