Search Results set_rowid_threshold




Overview
Explore in AI Chat

Overview

DBMS_CHANGE_NOTIFICATION is a SYS-owned PL/SQL package that implements the server-side registration and management infrastructure for Oracle Database Change Notification (DCN) within an Oracle E-Business Suite environment. In Oracle EBS 12.1.1 and 12.2.2, the package serves as the underlying mechanism by which database clients register interest in row-level or object-level changes and receive asynchronous notifications when those changes are committed. Rather than polling tables for changes, this package allows a registered client to be alerted when relevant data is modified, making it foundational to the continuous-query and event-driven features used by the middle-tier components.

The package is classified as OTHER in the documented ETRM metadata, and it depends on the supporting types CHNF$_REG_INFO and CHNF$_REG_INFO_OC4J, along with the STANDARD package. It is referenced by PUBLIC and by DBMS_CQ_NOTIFICATION, and it is itself referenced by one other package, confirming its role as a lower-level dependency surfaced through higher-level continuous-query APIs. The dependency on CHNF$_REG_INFO_OC4J indicates specific support for OC4J-based (Java middle-tier) registration paths that were relevant to the 12.1.1 and early 12.2.x application server stacks.

Key Procedures and Functions

The documented interface exposes seven procedures and functions, each participating in the registration lifecycle:

  • NEW_REG_START_OC4J — Initiates a new change notification registration tailored for OC4J middle-tier clients, establishing the registration context for subsequent operations.
  • NEW_REG_START — Begins a new registration in the general (non-OC4J-specific) case, initializing the registration handle used by later calls.
  • ENABLE_REG — Activates a previously created registration so that notifications begin to be generated for the associated queries or objects.
  • REG_END — Concludes a registration operation, finalizing the registration setup begun by NEW_REG_START or NEW_REG_START_OC4J.
  • DEREGISTER — Removes an existing registration, terminating further notifications for that registration.
  • SET_ROWID_THRESHOLD — Controls the row-level granularity at which change notifications are reported, governing when ROWID information is included.
  • CQ_NOTIFICATION_QUERYID — Supports the continuous-query model by relating a notification to its originating query identifier.

Parameter lists are intentionally omitted; the descriptions above reflect documented purpose only.

Tables Accessed

The ETRM documentation for this object does not list any application tables accessed through APPS synonyms. Operationally, the package interacts primarily with internal change-notification registration structures and the supporting registration-info types rather than with business tables directly. Any data observed is the result of queries registered by callers, not of direct DML performed by the package.

Usage Notes

DBMS_CHANGE_NOTIFICATION is not typically invoked directly from EBS forms or concurrent programs. It is instead consumed indirectly through DBMS_CQ_NOTIFICATION (continuous query notification) and by OC4J-based middle-tier services within the 12.1.1 and 12.2.2 application server architecture. Custom or framework code that requires event-driven notification of data changes would call the higher-level continuous-query API, which in turn depends on this package. Direct invocation of the low-level registration procedures should be reserved for specialized integrations where fine control over registration and ROWID thresholds is required, and only where the supported database feature set permits it.