Search Results key_type




Overview
Explore in AI Chat

Overview

SYS.PLITBLM is the Oracle-supplied PL/SQL package that implements the underlying runtime support for PL/SQL collection types (associative arrays, nested tables, and VARRAYs) within the Oracle E-Business Suite database tier. Although its owner is SYS and it is not an Applications-owned package in the strict sense, it is present in every Oracle EBS 12.1.1 and 12.2.2 database and is available to the APPS schema and all custom schemas through standard database privileges. It is classified in the ETRM repository as an "OTHER" API, reflecting that it is a kernel-level utility rather than a functional business API.

The package exposes a canonical set of collection manipulation primitives — count, first, last, exists, prior, next, delete, limit, trim, and extend — that mirror the built-in methods available on PL/SQL collections. Because these operations are implemented in C via the pragma interface(c, ...) directive, calls from PL/SQL are dispatched to native code rather than interpreted, providing the performance characteristics expected when collection methods are invoked inside tight loops in forms logic, concurrent programs, and workflow background processes.

Key Procedures and Functions

The documented API comprises twenty-seven functions and procedures:

  • COUNT — Returns the number of elements currently present in the collection.
  • FIRST — Returns the index of the first element in the collection.
  • LAST — Returns the index of the last element in the collection.
  • EXISTS — Tests whether an element exists at a given key/index position.
  • PRIOR — Returns the index immediately preceding a given index.
  • NEXT — Returns the index immediately following a given index.
  • DELETE — Overloaded to remove all elements, a single element, or a range of elements from a collection.
  • LIMIT — Returns the maximum size of a VARRAY collection.
  • TRIM — Removes trailing elements from a VARRAY or nested table.
  • EXTEND — Appends one or more elements to a VARRAY or nested table.

The key_type subtype is declared as binary_integer, and the element_count subtype is likewise binary_integer, with a source comment noting that natural was rejected as "too inefficient." These subtypes define the signature of index arguments throughout the package.

Tables Accessed

SYS.PLITBLM does not read or write any application tables. No APPS synonyms or base tables are referenced in the documented metadata. Its operations are purely in-memory, acting on PL/SQL collection variables passed by the caller. Persistence of collection contents is the responsibility of the calling program, which may subsequently insert rows into a temporary or permanent table.

Usage Notes

This package is invoked implicitly whenever PL/SQL collection methods are used in EBS code — Oracle Forms client-side PL/SQL, server-side packages, concurrent program logic, and workflow function activities all rely on it transparently. It is referenced by 288 other packages in the ETRM repository, confirming its role as a ubiquitous low-level dependency. Custom developers writing EBS extensions should treat SYS.PLITBLM as read-only infrastructure: it is never called directly by name in application code, and its signature should not be altered. Because it is owned by SYS, DBAs should exclude it from schema-level export/import operations and rely on standard database patching to keep it current.