Search Results set_attribute_c

Overview

CTXSYS.DRVLSB is a low-level Oracle Text (interMedia Text) driver package that serves as the internal workhorse behind the CTXSYS preference and section group management APIs. In the context of Oracle E-Business Suite 12.1.1 and 12.2.2, this package is not an EBS business application object; it is an Oracle-supplied database component that ships with the Oracle Text option. Its role is to execute the Data Definition Language (DDL) and administrative operations required to create, modify, and drop Oracle Text preferences, attributes, and section groups.

The package is defined with AUTHID CURRENT_USER, meaning it executes with the privileges of the calling user. The "_C" and "_NC" suffix convention distinguishes procedures that perform an implicit commit (_C) from those that do not (_NC), a pattern that allows callers to control transactional scope. The package is owned by CTXSYS and is referenced by three other packages within the Oracle Text stack, including the public CTX_DDL API surface. The search term "markup_clob_query" relates to Oracle Text query markup functionality, but DRVLSB itself focuses on the preference and section group definition layer rather than query execution.

Key Procedures and Functions

The documented interface exposes over one hundred procedures, organized into functional families:

• Preference management: CREATE_PREFERENCE_C, CREATE_PREFERENCE_NC, DROP_PREFERENCE_C, DROP_PREFERENCE_NC. These create and remove Oracle Text preferences (such as LEXER, WORDLIST, STOPLIST, and STORAGE preferences) that control index behavior.
• Attribute management: SET_ATTRIBUTE_C, SET_ATTRIBUTE_NC, UNSET_ATTRIBUTE_C, UNSET_ATTRIBUTE_NC. These assign or remove named attribute values on an existing preference or section group.
• Section group management: CREATE_SECTION_GROUP_C, CREATE_SECTION_GROUP_NC, DROP_SECTION_GROUP_C, DROP_SECTION_GROUP_NC. These manage section groups that define the structural markup recognized during indexing.
• Section group membership: ADD_ZONE_SECTION_C/NC, ADD_FIELD_SECTION_C/NC, ADD_SPECIAL_SECTION_C/NC, ADD_STOP_SECTION_C/NC. These add specific section types (zone, field, special, stop) to a section group, which controls how tagged or delimited content is parsed.

Each procedure is annotated with a PRAGMA SUPPLEMENTAL_LOG_DATA directive (AUTO or AUTO_WITH_COMMIT), ensuring the operations participate correctly in Oracle Data Guard and Streams replication environments. Note that parameter lists are intentionally not reproduced here.

Tables Accessed

The package references several dictionary and utility objects through APPS synonyms:

• DBA_USERS — queried to validate the invoking schema and resolve ownership context for AUTHID CURRENT_USER operations.
• DBMS_ASSERT — used to sanitize and validate identifiers supplied as preference, attribute, and section names, mitigating SQL injection risks inherent in dynamic DDL.
• DBMS_LOB — employed for large object manipulation when preference or section metadata is stored as LOB data.
• PLITBLM — a PL/SQL internal table/Lob management utility used for buffering and passing structured data.

The underlying preference and section group definitions are ultimately persisted in CTXSYS-owned dictionary tables (such as CTX_PREFERENCES and CTX_SECTION_GROUP), which this driver manipulates indirectly.

Usage Notes

DRVLSB is invoked indirectly rather than directly by EBS developers and administrators. Standard usage is through the public CTX_DDL package (for example, CTX_DDL.CREATE_PREFERENCE and CTX_DDL.ADD_ZONE_SECTION), which internally calls the corresponding DRVLSB driver procedures. In EBS, Oracle Text indexes are commonly applied to tables holding attachments, notes, or descriptive flexfield content, so any concurrent program, concurrent manager request, or Forms-based setup that builds or rebuilds a text index will traverse this package.

Custom code should generally avoid calling CTXSYS.DRVLSB directly, since it is an internal driver subject to change across database versions; the supported entry point remains CTX_DDL. When troubleshooting text index creation failures in EBS 12.1.1 or 12.2.2, DBAs may trace execution through DRVLSB to isolate the exact DDL step that failed. Because the "_C" variants commit implicitly, they should not be used inside open transactions that require rollback capability, whereas the "_NC" variants defer commit control to the caller.