Search Results dbms_sqltcb_internal




Overview
Explore in AI Chat

Overview

SYS.DBMS_SQLTCB_INTERNAL is an Oracle-supplied, internal PL/SQL package owned by the SYS schema. In the Oracle E-Business Suite 12.1.1 and 12.2.2 environments, it functions as a supporting utility within Oracle's SQL Repair Advisor and SQL diagnostic infrastructure. The package name derives from "SQL Tuning/Test Case Builder internal" and reflects its role in the automated construction of reproducible SQL test cases, which Oracle Database uses to capture, replay, and diagnose problematic SQL statements. For EBS administrators and technical consultants, DBMS_SQLTCB_INTERNAL is not a business-facing API; it is an engine-room component called by higher-level diagnostic packages. The ETRM metadata confirms the package is VALID and classifies it under API category OTHER, indicating that Oracle does not document it as a public, supported interface. Its presence in an EBS instance is therefore expected and benign — it is part of the standard database component set delivered with the certified Oracle Database version bundled with the EBS technology stack.

Key Procedures and Functions

The ETRM documentation for this object enumerates zero documented procedures or functions. This is consistent with the package's classification as an internal, proprietary Oracle utility whose callable interfaces are deliberately withheld from public documentation. No parameter lists are published, and none should be assumed or invented during troubleshooting. Practically, the package exposes internal entry points that manipulate SQL test case payloads — generating test case definitions, serializing bind metadata, and coordinating with the SQL Repair Advisor workflow. These routines are invoked programmatically by Oracle's own diagnostic stack rather than by application code or end users. Because the specification is wrapped and unsupported, any direct invocation is at the customer's risk and is not covered by Oracle Support for EBS.

Tables Accessed

The documented dependency list shows that DBMS_SQLTCB_INTERNAL reads or writes the following objects via APPS synonyms: DBMS_OUTLN_EDIT, KU$_JOBDESC, KU$_JOBSTATUS, KU$_LOGENTRY, and KU$_STATUS. The KU$ family comprises Oracle's internal data dictionary views for job management, job status tracking, log entries, and general status reporting used by database utilities such as the SQL Tuning Advisor and SQL Access Advisor. DBMS_OUTLN_EDIT relates to stored outline editing, an older plan-stability mechanism. The presence of these dependencies indicates that the package participates alongside job-scheduling and logging infrastructure, persisting diagnostic metadata and recording the outcome of test case generation activities. It also references SQLSET_ROW, SQL_BINDS, XMLSEQUENCE, and XMLTYPE, reflecting its use of XML structures to represent SQL statements and their bind variables during test case assembly.

Usage Notes

This package is not invoked from EBS forms, concurrent programs, or supported custom code. It is called internally by SYS.DBMS_SQLDIAG, the SQL Repair Advisor package, which is itself the entry point exposed through database tools such as Enterprise Manager and the DBMS_SQLDIAG API. In an EBS 12.1.1 or 12.2.2 context, administrators may encounter the package only indirectly: through Automatic Workload Repository snapshots, SQL Tuning Advisor runs, or while creating SQL test cases to escalate a performance defect to Oracle Support. The package is referenced by exactly one other package (DBMS_SQLDIAG) and is self-referencing, confirming its narrow, internal role. It should never be modified, recompiled out of sequence, or relied upon as a stable interface. Any EBS patch analysis or cloning activity that reports this package as VALID requires no action; an INVALID status would typically be resolved by running catalog or utlrp scripts against the database.