Search Results drop_stoplist

Overview

The CTXSYS.DRISPL package is an Oracle Text (formerly interMedia Text) internal PL/SQL package that provides the underlying implementation for stoplist management operations. A stoplist is a database object that identifies words or terms which should be excluded from a text index — typically common words such as "the," "and," or "of" that carry little search significance. Within the Oracle E-Business Suite Release 12.1.1 and 12.2.2 environments, this package underpins the text indexing and search capabilities that many EBS modules rely upon, including Oracle iStore, Oracle iProcurement, Oracle Knowledge Management, and various Applications Technology components that use Oracle Text indexes against descriptive or document-oriented data.

The package is owned by the CTXSYS schema, the standard schema for Oracle Text objects, and is classified in the ETRM repository with an API classification of OTHER, indicating that it is a system-level utility rather than a formally published EBS business API. As such, direct invocation by EBS customers is uncommon; the package is normally called internally by Oracle Text infrastructure or by higher-level EBS packages that manipulate text indexes.

Key Procedures and Functions

The package exposes eleven documented program units, of which the first nine relate primarily to stoplist lifecycle management:

• CREATE_STOPLIST — Creates a new stoplist with a specified name and type, supporting an implicit-commit preference. This is the procedure most directly associated with the user's search term "create_stoplist."
• DROP_STOPLIST — Removes an existing stoplist by name.
• DROP_USER_STOPLISTS — Drops all stoplists owned by a given user, optionally defaulting to a specific user context.
• ADD_STOPOBJ — Adds a stopword or stoppattern object to a stoplist, with options for language and language dependence.
• REMOVE_STOPOBJ — Removes a previously added stopword entry from a stoplist.
• COPY_STOPLIST — A function that duplicates a stoplist, returning preference record information and an output row count.
• INDEXADDSTOPWORD — Adds a stopword directly to an already-existing text index.
• INDEXREMSTOPWORD — Removes a stopword from an existing index.
• GETINDEXSTOPWORDS — Reports the stopwords currently associated with an index.
• MIGRATETOMULTISTOPLIST — Supports migration toward multi-stoplist configurations.
• GETSPLLANG — Returns language information associated with a stoplist.

Tables Accessed

The documented tables accessed via APPS synonyms include PLITBLM, an Oracle Text internal table used to store stopword and language-related index data. Access to this table supports both the stoplist definition procedures and the index-oriented procedures that read or modify stopword membership for existing text indexes.

Usage Notes

Because DRISPL is an internal Oracle Text package, it is not intended for direct invocation from EBS forms or concurrent programs. In practice, it is invoked indirectly when EBS modules create or maintain Oracle Text indexes, for example during index creation, rebuild, or optimization. Custom code that needs to manipulate stoplists should generally prefer the supported CTX_DDL package interfaces, such as CTX_DDL.CREATE_STOPLIST and CTX_DDL.ADD_STOPWORD, which wrap the same underlying functionality in a documented, supported API. The ETRM metadata indicates that DRISPL is referenced by approximately ten other packages within the environment, underscoring its role as a foundational dependency rather than a customer-facing entry point.