Search Results ora_server_error_depth




Overview
Explore in AI Chat

Overview

SYS.DBMS_RESUMABLE is a core Oracle Server-supplied PL/SQL package body owned by the SYS schema. Its business function within Oracle E-Business Suite 12.1.1 and 12.2.2 is to manage the resumable space allocation feature of the Oracle database, which allows a long-running operation to be suspended rather than fail outright when a recoverable error is encountered, such as an out-of-space condition, an exceeded maximum extent, or an unavailable temporary tablespace. In the EBS context, this capability protects concurrent programs, online patching operations, and large data-intensive reports from aborting prematurely. The package body is documented with a VALID status in the ETRM repository and is classified as an OTHER API, reflecting its role as infrastructure rather than an application-level business API. The ETRM metadata confirms that SYS.DBMS_RESUMABLE references DBMS_RESUMABLE_LIB and STANDARD internally, and that it is not referenced by any database object, confirming its role as an underlying engine component.

Key Procedures and Functions

The documented API surface consists of six procedures and functions:

  • ABORT — Terminates a resumable operation that has been suspended, forcing the statement to raise an error rather than continue waiting for the interrupting condition to clear.
  • SET_SESSION_TIMEOUT — Configures the timeout interval for the current session, governing how long a suspended operation may remain in the resumable state before it is automatically aborted.
  • GET_SESSION_TIMEOUT — Returns the currently effective timeout value for the session, allowing diagnostic code or administrative utilities to inspect the active configuration.
  • SET_TIMEOUT — Establishes the timeout value for the current resumable statement, overriding the session-level setting for the duration of that operation.
  • GET_TIMEOUT — Retrieves the timeout currently associated with the running resumable statement.
  • SPACE_ERROR_INFO — Returns structured information describing any space-related error that has suspended the operation, distinguishing the type of error and enabling the application to react intelligently, for example by extending a tablespace or clearing space before resumption.

Tables Accessed

The ETRM dependency metadata records that the package body references the following tables via APPS synonyms: ORA_SERVER_ERROR, ORA_SERVER_ERROR_DEPTH, and ORA_SERVER_ERROR_PARAM. These are dynamic performance structures within the Oracle Server that capture runtime error context.

  • ORA_SERVER_ERROR — Holds the top-level error record for the active session, supplying the error number and message associated with a suspended resumable operation.
  • ORA_SERVER_ERROR_DEPTH — Tracks the nesting depth of the error stack, allowing the package to determine how many layers of error context are available.
  • ORA_SERVER_ERROR_PARAM — Stores the individual error parameters, which is directly relevant to the ora_server_error_param search term that surfaced this object. This table underpins the parameter substitution used when the package reports detailed error text.

Usage Notes

In EBS 12.1.1 and 12.2.2, DBMS_RESUMABLE is invoked indirectly by the database kernel rather than by application forms. It is most commonly exercised when a concurrent program performing large inserts or index rebuilds encounters a space condition. Administrators may query session timeout settings using GET_SESSION_TIMEOUT and adjust them with SET_SESSION_TIMEOUT during maintenance windows. Custom PL/SQL code that performs bulk operations can call SET_TIMEOUT to extend tolerance during batch processing. The SPACE_ERROR_INFO function is typically used in exception handlers to log or respond to space errors programmatically. Because the package is owned by SYS, EXECUTE privileges are granted to PUBLIC, and it should never be modified; any customization must occur in the calling application code.