Search Results dbms_reco_script_invok

Overview

DBMS_RECO_SCRIPT_INVOK is an Oracle-supplied PL/SQL package body owned by the SYS schema and delivered as part of the Oracle Database kernel, not as an Oracle E-Business Suite application-layer object. Its name derives from "recoverable script invocation," and its role is to provide the invocation layer for Oracle's recoverable script infrastructure. A recoverable script is a long-running, restartable operation, such as an online redefinition, a patch-driven DDL sequence, or a Streams-related DDL script, that Oracle can resume after an interruption without leaving the dictionary in an inconsistent state. DBMS_RECO_SCRIPT_INVOK sits between the higher-level recoverable script coordinator and the lower-level script execution internals, marshalling the calls needed to start, drive, and complete such scripts.

In Oracle EBS 12.1.1 and 12.2.2, this package is not one of the Application Object Library or ETRM APIs that a functional consultant would configure. It is present because the EBS database sits on an Oracle RDBMS release that includes the recoverable script framework, and because EBS patching and online operations rely on that framework. The package is documented with a status of VALID and carries an API classification of OTHER, indicating it is not a documented public extension point for customer code.

Key Procedures and Functions

The ETRM object metadata records zero documented procedures or functions for this package body. No public callable subprograms are exposed in the reference documentation, and no parameter lists are published. This is consistent with an internal kernel package whose entry points are invoked only by other Oracle-supplied packages rather than by application code. Consultants and developers should not attempt to enumerate or call member procedures directly from EBS forms, concurrent programs, or custom PL/SQL, since the interface is neither documented nor guaranteed to remain stable across database patch levels.

Tables Accessed

The documented metadata lists no base tables or APPS synonyms referenced by this package body. Its dependencies are exclusively other PL/SQL units, including DBMS_RECOVERABLE_SCRIPT, DBMS_RECO_SCRIPT_INT, DBMS_SQL, DBMS_SYS_SQL, DBMS_LOGREP_UTIL, DBMS_LOGREP_UTIL_INVOK, DBMS_REPCAT_SQL_UTL, DBMS_STREAMS_MT, DBMS_STANDARD, and STANDARD. Database access therefore occurs indirectly, through these dependent packages, which in turn read and write the underlying recoverable script dictionary views and dynamic SQL statements.

Usage Notes

The package is not referenced by any database object within the EBS application schema, meaning no EBS form, concurrent program, or custom package calls it directly. Instead, it is reached through the recoverable script call chain when Oracle executes operations that require restartability, such as online table redefinition, editioning changes, or Streams and Advanced Replication maintenance performed against the EBS database.

In an EBS context, this activity is most commonly observed during patching and upgrade windows, when AutoPatch or the online patching infrastructure in 12.2.2 triggers DDL-intensive operations on the database. Troubleshooting efforts involving DBMS_RECO_SCRIPT_INVOK should focus on the dependent packages and the database alert log rather than on EBS application logs. Because the object is SYS-owned and internal, it should never be modified, wrapped, or invoked directly, and any invalid state should be resolved by recompiling with the underlying RDBMS patch set or by contacting Oracle Support.

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 BODY: SYS.DBMS_RECO_SCRIPT_INVOK 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_RECO_SCRIPT_INVOK, status:VALID,
PACKAGE: SYS.DBMS_RECO_SCRIPT_INVOK 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_RECO_SCRIPT_INVOK, status:VALID,
PACKAGE: SYS.DBMS_RECO_SCRIPT_INVOK 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_RECO_SCRIPT_INVOK, status:VALID,
PACKAGE BODY: SYS.DBMS_RECOVERABLE_SCRIPT 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_RECOVERABLE_SCRIPT, status:VALID,
PACKAGE: SYS.DBMS_RECO_SCRIPT_INVOK 12.2.2
PACKAGE BODY: SYS.DBMS_STREAMS_RPC 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_STREAMS_RPC, status:VALID,
PACKAGE: SYS.DBMS_RECO_SCRIPT_INT 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_RECO_SCRIPT_INT, status:VALID,
PACKAGE: SYS.DBMS_RECOVERABLE_SCRIPT 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_RECOVERABLE_SCRIPT, status:VALID,
PACKAGE: SYS.DBMS_LOGREP_UTIL_INVOK 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_LOGREP_UTIL_INVOK, status:VALID,
PACKAGE BODY: SYS.DBMS_RECOVERABLE_SCRIPT 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_RECOVERABLE_SCRIPT, status:VALID,
PACKAGE BODY: SYS.DBMS_RECO_SCRIPT_INVOK 12.2.2
PACKAGE: SYS.DBMS_RECO_SCRIPT_INVOK 12.1.1
PACKAGE: SYS.DBMS_STREAMS_MT 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_STREAMS_MT, status:VALID,
PACKAGE BODY: SYS.DBMS_RECO_SCRIPT_INVOK 12.1.1
PACKAGE: SYS.DBMS_RECO_SCRIPT_INT 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_RECO_SCRIPT_INT, status:VALID,
PACKAGE BODY: SYS.DBMS_STREAMS_RPC 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_STREAMS_RPC, 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: SYS.DBMS_RECOVERABLE_SCRIPT 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_RECOVERABLE_SCRIPT, status:VALID,
PACKAGE: SYS.DBMS_LOGREP_UTIL_INVOK 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_LOGREP_UTIL_INVOK, status:VALID,
PACKAGE BODY: SYS.DBMS_STREAMS_MT 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_STREAMS_MT, status:VALID,
PACKAGE: SYS.DBMS_STREAMS_MT 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_STREAMS_MT, status:VALID,
PACKAGE BODY: SYS.DBMS_STREAMS_MT 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_STREAMS_MT, status:VALID,
PACKAGE: SYS.DBMS_SYS_SQL 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_SYS_SQL, status:VALID,
PACKAGE: SYS.DBMS_LOGREP_UTIL 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_LOGREP_UTIL, status:VALID,
PACKAGE: SYS.DBMS_LOGREP_UTIL 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_LOGREP_UTIL, status:VALID,
PACKAGE: SYS.DBMS_SYS_SQL 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_SYS_SQL, 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,
12.1.1 DBA Data 12.1.1
12.2.2 DBA Data 12.2.2
12.2.2 DBA Data 12.2.2
12.1.1 DBA Data 12.1.1
SYS.DBMS_STREAMS_RPC dependencies on DBMS_RECO_SCRIPT_INVOK 12.2.2
SYS.DBMS_STREAMS_MT dependencies on DBMS_RECO_SCRIPT_INVOK 12.2.2
SYS.DBMS_RECO_SCRIPT_INVOK dependencies on DBMS_RECO_SCRIPT_INVOK 12.1.1
SYS.DBMS_STREAMS_RPC dependencies on DBMS_RECO_SCRIPT_INVOK 12.1.1
SYS.DBMS_RECOVERABLE_SCRIPT dependencies on DBMS_RECO_SCRIPT_INVOK 12.2.2
SYS.DBMS_RECOVERABLE_SCRIPT dependencies on DBMS_RECO_SCRIPT_INVOK 12.1.1
SYS.DBMS_STREAMS_MT dependencies on DBMS_RECO_SCRIPT_INVOK 12.1.1
SYS.DBMS_RECO_SCRIPT_INVOK dependencies on DBMS_RECO_SCRIPT_INVOK 12.2.2
PACKAGE: SYS.DBMS_STANDARD 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_STANDARD, status:VALID,
PACKAGE: SYS.DBMS_STANDARD 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_STANDARD, status:VALID,
PACKAGE: SYS.STANDARD 12.1.1
owner:SYS, object_type:PACKAGE, object_name:STANDARD, status:VALID,