Search Results dbms_repcat_sql_utl

Overview

SYS.DBMS_REPCAT_SQL_UTL is an Oracle-supplied PL/SQL package body that forms part of the symmetric replication infrastructure underlying Oracle E-Business Suite releases 12.1.1 and 12.2.2. Its central business function is to execute dynamic SQL and Data Definition Language (DDL) statements on behalf of the replication administration layer. When an EBS administrator invokes administrative APIs to create, alter, suspend, or resume materialized view replication groups, those operations require controlled execution of SQL and DDL text generated at runtime. DBMS_REPCAT_SQL_UTL provides that execution engine, parsing statement strings and dispatching them through Oracle's dynamic SQL facilities while applying the validation and error-handling discipline required by the replication catalog.

The package is owned by SYS and carries VALID status in the documented environment. The ETRM metadata records zero independently documented procedures or functions for this object, and no tables are accessed through APPS synonyms; its role is therefore internal to the replication stack rather than a directly callable application programming interface.

Key Procedures and Functions

The ETRM documentation exposes no individually named procedures or functions for this package body, so parameter-level detail cannot be asserted. This absence of documented entry points is consistent with an internal helper package whose routines are consumed by sibling replication packages rather than by end users directly. Functionally, the package supplies the dynamic SQL execution primitives that the higher-level replication administration APIs rely upon when applying generated DDL and DML against the replication catalog and replicated objects.

Tables Accessed

Per the documented dependency list, SYS.DBMS_REPCAT_SQL_UTL directly references only the SYS.DBA_ERRORS data dictionary view and the STANDARD package. The DBA_ERRORS dependency confirms that the package inspects compilation and runtime error information, a standard requirement for dynamically executed SQL where failures must be reported meaningfully. No application tables are recorded as accessed through APPS synonyms, which reinforces the conclusion that the package operates on statement text supplied by calling programs rather than on fixed application data structures.

Usage Notes

This package is not intended for direct invocation from EBS forms, concurrent programs, or custom code. It is invoked indirectly through the replication administration APIs in the DBMS_REPCAT family. Its dependency chain is significant: the package references DBMS_ASSERT, DBMS_LOB, DBMS_REPCAT_DECL, DBMS_REPCAT_UTL, DBMS_SNAPSHOT_UTL, DBMS_SQL, DBMS_SYS_ERROR, DBMS_SYS_SQL, and DBMS_UTILITY, and it is itself referenced by thirteen other packages. The presence of DBMS_ASSERT indicates defensive validation of SQL identifiers, a safeguard against malformed or injected statement text.

In EBS 12.1.1 and 12.2.2 environments, the package remains a fixed, Oracle-maintained component. Customizations should never modify it; instead, administrators invoking replication setup should rely on supported Oracle APIs, with this package functioning transparently beneath them. Any recompilation or invalidation of this package can affect the broader replication dependency tree and should be treated as an infrastructure-level event.

PACKAGE BODY: SYS.DBMS_REPCAT_SQL_UTL 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_REPCAT_SQL_UTL, status:VALID,
PACKAGE: SYS.DBMS_REPCAT_SQL_UTL 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_REPCAT_SQL_UTL, status:VALID,
PACKAGE: SYS.DBMS_REPCAT_SQL_UTL 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_REPCAT_SQL_UTL, status:VALID,
PACKAGE BODY: SYS.DBMS_REPCAT_SQL_UTL 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_REPCAT_SQL_UTL, status:VALID,
PACKAGE: SYS.DBMS_REPCAT_SQL_UTL 12.1.1
PACKAGE: SYS.DBMS_REPCAT_SQL_UTL 12.2.2
PACKAGE BODY: SYS.DBMS_RECO_SCRIPT_INVOK 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_RECO_SCRIPT_INVOK, status:VALID,
PACKAGE BODY: SYS.DBMS_RECO_SCRIPT_INVOK 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_RECO_SCRIPT_INVOK, status:VALID,
PACKAGE: SYS.DBMS_SNAPSHOT_UTL 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_SNAPSHOT_UTL, status:VALID,
PACKAGE: SYS.DBMS_SNAPSHOT_UTL 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_SNAPSHOT_UTL, status:VALID,
PACKAGE BODY: SYS.DBMSOBJG2 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMSOBJG2, status:VALID,
PACKAGE BODY: SYS.DBMS_REPCAT_ADMIN 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_REPCAT_ADMIN, status:VALID,
PACKAGE BODY: SYS.DBMS_RECTIFIER_DIFF_INTERNAL 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_RECTIFIER_DIFF_INTERNAL, status:VALID,
PACKAGE: SYS.DBMS_SYS_SQL 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_SYS_SQL, status:VALID,
PACKAGE BODY: SYS.DBMSOBJG_DP 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMSOBJG_DP, status:VALID,
PACKAGE BODY: SYS.DBMS_REPCAT_ADMIN 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_REPCAT_ADMIN, status:VALID,
PACKAGE BODY: SYS.DBMSOBJG2 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMSOBJG2, status:VALID,
PACKAGE BODY: SYS.DBMS_RECTIFIER_DIFF_INTERNAL 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_RECTIFIER_DIFF_INTERNAL, status:VALID,
PACKAGE BODY: SYS.DBMSOBJG_DP 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMSOBJG_DP, status:VALID,
PACKAGE BODY: SYS.DBMS_DEFER_REPCAT 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_DEFER_REPCAT, status:VALID,
PACKAGE BODY: SYS.DBMS_DEFER_REPCAT 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_DEFER_REPCAT, status:VALID,
VIEW: SYS.DBA_ERRORS 12.1.1
owner:SYS, object_type:VIEW, object_name:DBA_ERRORS, status:VALID,
PACKAGE BODY: SYS.DBMS_REPCAT_RQ 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_REPCAT_RQ, status:VALID,
PACKAGE BODY: SYS.DBMSOBJG 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMSOBJG, status:VALID,
PACKAGE: SYS.DBMS_SYS_SQL 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_SYS_SQL, status:VALID,
PACKAGE BODY: SYS.DBMS_REPCAT_SQL_UTL 12.1.1
PACKAGE BODY: SYS.DBMS_REPCAT_SQL_UTL 12.2.2
PACKAGE BODY: SYS.DBMSOBJG 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMSOBJG, status:VALID,
PACKAGE BODY: SYS.DBMS_REPCAT_RQ 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_REPCAT_RQ, status:VALID,
PACKAGE BODY: SYS.DBMS_REPCAT_SNA_UTL 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_REPCAT_SNA_UTL, status:VALID,
PACKAGE BODY: SYS.DBMS_REPCAT_MAS 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_REPCAT_MAS, status:VALID,
PACKAGE BODY: SYS.DBMS_REPCAT_UTL4 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_REPCAT_UTL4, status:VALID,
VIEW: SYS.DBA_ERRORS 12.2.2
owner:SYS, object_type:VIEW, object_name:DBA_ERRORS, status:VALID,
PACKAGE BODY: SYS.DBMS_REPCAT_SNA_UTL 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_REPCAT_SNA_UTL, status:VALID,
PACKAGE BODY: SYS.DBMS_REPCAT_MAS 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_REPCAT_MAS, status:VALID,
PACKAGE BODY: SYS.DBMS_REPCAT_UTL4 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_REPCAT_UTL4, status:VALID,
PACKAGE BODY: SYS.DBMS_REPCAT_UTL3 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_REPCAT_UTL3, status:VALID,
PACKAGE BODY: SYS.DBMS_REPCAT_UTL3 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_REPCAT_UTL3, status:VALID,
PACKAGE BODY: SYS.DBMS_REPCAT_UTL 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_REPCAT_UTL, status:VALID,
PACKAGE BODY: SYS.DBMS_REPCAT_UTL 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_REPCAT_UTL, status:VALID,
PACKAGE: SYS.DBMS_REPCAT_UTL 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_REPCAT_UTL, status:VALID,
PACKAGE: SYS.DBMS_REPCAT_UTL 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_REPCAT_UTL, status:VALID,
PACKAGE: SYS.DBMS_REPCAT_DECL 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_REPCAT_DECL, status:VALID,
PACKAGE: SYS.DBMS_REPCAT_DECL 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_REPCAT_DECL, status:VALID,
PACKAGE: SYS.DBMS_UTILITY 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_UTILITY, status:VALID,
PACKAGE: SYS.DBMS_UTILITY 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_UTILITY, status:VALID,
PACKAGE: SYS.DBMS_SQL 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_SQL, status:VALID,
PACKAGE: SYS.DBMS_SQL 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_SQL, status:VALID,
PACKAGE: SYS.DBMS_LOB 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_LOB, status:VALID,
PACKAGE: SYS.DBMS_LOB 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_LOB, status:VALID,